Tuesday, November 30, 2021

GL Table Changes R12 in Oracle APPS


SL_NO

11i TABLES                                                 

R12 TABLES

1

GL_ACCOUNT_HIERARCHIES

 GL_ACCOUNT_HIERARCHIES

2

GL_AHE_DETAIL_RANGES_GT

 GL_AHE_DETAIL_RANGES_GT

3

GL_ALLOC_BATCHES

 GL_ALLOC_BATCHES

4

GL_ALLOC_FORMULA_LINES

 GL_ALLOC_FORMULA_LINES

5

GL_ALLOC_FORMULAS

 GL_ALLOC_FORMULAS

6

GL_ALLOC_HISTORY

 GL_ALLOC_HISTORY

7

GL_ALLOC_SEGVALS_INT

 

8

GL_APPLICATION_GROUPS

 

9

GL_ARCHIVE_HISTORY

 GL_ARCHIVE_HISTORY

10

GL_AUTHORIZATION_LIMITS

 GL_AUTHORIZATION_LIMITS

11

GL_AUTO_ALLOC_BAT_HIST_DET

 GL_AUTO_ALLOC_BAT_HIST_DET

12

GL_AUTO_ALLOC_BATCH_HISTORY

 GL_AUTO_ALLOC_BATCH_HISTORY

13

GL_AUTO_ALLOC_BATCHES

 GL_AUTO_ALLOC_BATCHES

14

GL_AUTO_ALLOC_REV_BATCHES

 GL_AUTO_ALLOC_REV_BATCHES

15

GL_AUTO_ALLOC_SET_HISTORY

GL_AUTO_ALLOC_SET_HISTORY

16

GL_AUTO_ALLOC_SETS

 GL_AUTO_ALLOC_SETS

17

GL_AUTOMATIC_POSTING_OPTIONS

 GL_AUTOMATIC_POSTING_OPTIONS

18

GL_AUTOMATIC_POSTING_SETS

 GL_AUTOMATIC_POSTING_SETS

19

GL_AUTOREVERSE_OPTIONS

 GL_AUTOREVERSE_OPTIONS

20

GL_BALANCES

 GL_BALANCES

21

GL_BALANCES_DELTA

 GL_BALANCES_DELTA

22

GL_BALANCES_DELTA_INTERIM

GL_BALANCES_DELTA_INTERIM

23

GL_BC_DUAL

 GL_BC_DUAL

24

GL_BC_DUAL2

 GL_BC_DUAL2

25

GL_BC_EVENT_TIMESTAMPS

 GL_BC_EVENT_TIMESTAMPS

26

GL_BC_OPTION_DETAILS

 GL_BC_OPTION_DETAILS

27

GL_BC_OPTIONS

 GL_BC_OPTIONS

28

GL_BC_PACKET_ARRIVAL_ORDER

 GL_BC_PACKET_ARRIVAL_ORDER

29

GL_BC_PACKETS

 GL_BC_PACKETS

30

GL_BC_PERIOD_MAP

 GL_BC_PERIOD_MAP

31

GL_BIS_SEGVAL_INT

 GL_BIS_SEGVAL_INT

32

GL_BUDGET_ASSIGNMENT_RANGES

 GL_BUDGET_ASSIGNMENT_RANGES

33

GL_BUDGET_ASSIGNMENTS

 GL_BUDGET_ASSIGNMENTS

34

GL_BUDGET_BATCHES

 GL_BUDGET_BATCHES

35

GL_BUDGET_ENTITIES

 GL_BUDGET_ENTITIES

36

GL_BUDGET_FROZEN_RANGES

 GL_BUDGET_FROZEN_RANGES

37

GL_BUDGET_INTERFACE

 GL_BUDGET_INTERFACE

38

GL_BUDGET_INTERIM

 GL_BUDGET_INTERIM

39

GL_BUDGET_PERIOD_RANGES

 GL_BUDGET_PERIOD_RANGES

40

GL_BUDGET_RANGE_INTERIM

 GL_BUDGET_RANGE_INTERIM

41

GL_BUDGET_TYPES

 GL_BUDGET_TYPES

42

GL_BUDGET_VERSIONS

 GL_BUDGET_VERSIONS

43

GL_BUDGETS

GL_BUDGETS

44

GL_CARRYFORWARD_RANGES

 GL_CARRYFORWARD_RANGES

45

GL_CODE_COMBINATIONS

 GL_CODE_COMBINATIONS

46

GL_CONCURRENCY_CONTROL

 GL_CONCURRENCY_CONTROL

47

GL_CONCURRENT_SCHEDULES

 GL_CONCURRENT_SCHEDULES

48

GL_CONS_BATCHES

 GL_CONS_BATCHES

49

GL_CONS_FLEX_HIERARCHIES

 GL_CONS_FLEX_HIERARCHIES

50

GL_CONS_FLEXFIELD_MAP

 GL_CONS_FLEXFIELD_MAP

 


Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...