DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000020_BC_PKG dependencies on FND_LOOKUP_VALUES

Line 13968: , fnd_lookup_values fvl9

13964: , CST_XLA_RCV_REF_V h3
13965: , PO_DISTS_REF_V h4
13966: , PO_HEADERS_REF_V h5
13967: , PSA_CST_XLA_UPG_V h6
13968: , fnd_lookup_values fvl9
13969: , fnd_lookup_values fvl42
13970: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
13971: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13972: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 13969: , fnd_lookup_values fvl42

13965: , PO_DISTS_REF_V h4
13966: , PO_HEADERS_REF_V h5
13967: , PSA_CST_XLA_UPG_V h6
13968: , fnd_lookup_values fvl9
13969: , fnd_lookup_values fvl42
13970: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
13971: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13972: AND xet.event_class_code = C_EVENT_CLASS_CODE
13973: AND h1.event_id = xet.event_id

Line 14215: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

14211: l_balance_type_code VARCHAR2(1) :=NULL;
14212: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
14213:
14214: --
14215: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
14216: --
14217:
14218: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
14219: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 14310: , fnd_lookup_values fvl9

14306: , CST_XLA_RCV_REF_V h3
14307: , PO_DISTS_REF_V h4
14308: , PO_HEADERS_REF_V h5
14309: , PSA_CST_XLA_UPG_V h6
14310: , fnd_lookup_values fvl9
14311: , fnd_lookup_values fvl42
14312: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
14313: and xet.event_class_code = C_EVENT_CLASS_CODE
14314: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 14311: , fnd_lookup_values fvl42

14307: , PO_DISTS_REF_V h4
14308: , PO_HEADERS_REF_V h5
14309: , PSA_CST_XLA_UPG_V h6
14310: , fnd_lookup_values fvl9
14311: , fnd_lookup_values fvl42
14312: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
14313: and xet.event_class_code = C_EVENT_CLASS_CODE
14314: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
14315: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h4.po_header_id (+) AND h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 15291: , fnd_lookup_values fvl9

15287: , CST_XLA_INV_TXN_TYPES_REF_V h6
15288: , PO_REQ_DISTS_REF_V h7
15289: , PO_REQ_HEADERS_REF_V h8
15290: , PSA_CST_XLA_UPG_V h9
15291: , fnd_lookup_values fvl9
15292: , fnd_lookup_values fvl42
15293: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
15294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15295: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 15292: , fnd_lookup_values fvl42

15288: , PO_REQ_DISTS_REF_V h7
15289: , PO_REQ_HEADERS_REF_V h8
15290: , PSA_CST_XLA_UPG_V h9
15291: , fnd_lookup_values fvl9
15292: , fnd_lookup_values fvl42
15293: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
15294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15295: AND xet.event_class_code = C_EVENT_CLASS_CODE
15296: AND h1.event_id = xet.event_id

Line 15538: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

15534: l_balance_type_code VARCHAR2(1) :=NULL;
15535: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
15536:
15537: --
15538: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
15539: --
15540:
15541: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
15542: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 15651: , fnd_lookup_values fvl9

15647: , CST_XLA_INV_TXN_TYPES_REF_V h6
15648: , PO_REQ_DISTS_REF_V h7
15649: , PO_REQ_HEADERS_REF_V h8
15650: , PSA_CST_XLA_UPG_V h9
15651: , fnd_lookup_values fvl9
15652: , fnd_lookup_values fvl42
15653: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
15654: and xet.event_class_code = C_EVENT_CLASS_CODE
15655: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 15652: , fnd_lookup_values fvl42

15648: , PO_REQ_DISTS_REF_V h7
15649: , PO_REQ_HEADERS_REF_V h8
15650: , PSA_CST_XLA_UPG_V h9
15651: , fnd_lookup_values fvl9
15652: , fnd_lookup_values fvl42
15653: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
15654: and xet.event_class_code = C_EVENT_CLASS_CODE
15655: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
15656: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.BUS_FLOW_REQ_DIST_ID=h7.REQ_DISTRIBUTION_ID (+) AND h4.BUS_FLOW_REQ_ID = h8.REQ_ID (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 16552: , fnd_lookup_values fvl9

16548: , CST_XLA_INV_HEADERS_V h1
16549: , CST_XLA_INV_REF_V h3
16550: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16551: , CST_XLA_INV_TXN_TYPES_REF_V h5
16552: , fnd_lookup_values fvl9
16553: , fnd_lookup_values fvl42
16554: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
16555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16556: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 16553: , fnd_lookup_values fvl42

16549: , CST_XLA_INV_REF_V h3
16550: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16551: , CST_XLA_INV_TXN_TYPES_REF_V h5
16552: , fnd_lookup_values fvl9
16553: , fnd_lookup_values fvl42
16554: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
16555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16556: AND xet.event_type_code = C_EVENT_TYPE_CODE
16557: AND h1.event_id = xet.event_id

Line 16833: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

16829: l_balance_type_code VARCHAR2(1) :=NULL;
16830: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
16831:
16832: --
16833: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
16834: --
16835:
16836: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
16837: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 16918: , fnd_lookup_values fvl9

16914: , CST_XLA_INV_HEADERS_V h1
16915: , CST_XLA_INV_REF_V h3
16916: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16917: , CST_XLA_INV_TXN_TYPES_REF_V h5
16918: , fnd_lookup_values fvl9
16919: , fnd_lookup_values fvl42
16920: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
16921: and xet.event_type_code = C_EVENT_TYPE_CODE
16922: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 16919: , fnd_lookup_values fvl42

16915: , CST_XLA_INV_REF_V h3
16916: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16917: , CST_XLA_INV_TXN_TYPES_REF_V h5
16918: , fnd_lookup_values fvl9
16919: , fnd_lookup_values fvl42
16920: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
16921: and xet.event_type_code = C_EVENT_TYPE_CODE
16922: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
16923: AND h3.ref_transaction_id = h1.transaction_id AND h4.INVENTORY_ITEM_ID = h1.INVENTORY_ITEM_ID AND h4.ORGANIZATION_ID = h1.ORGANIZATION_ID AND h5.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 17799: , fnd_lookup_values fvl9

17795: , CST_XLA_INV_HEADERS_V h1
17796: , CST_XLA_INV_REF_V h3
17797: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
17798: , CST_XLA_INV_TXN_TYPES_REF_V h5
17799: , fnd_lookup_values fvl9
17800: , fnd_lookup_values fvl42
17801: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
17802: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17803: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 17800: , fnd_lookup_values fvl42

17796: , CST_XLA_INV_REF_V h3
17797: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
17798: , CST_XLA_INV_TXN_TYPES_REF_V h5
17799: , fnd_lookup_values fvl9
17800: , fnd_lookup_values fvl42
17801: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
17802: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17803: AND xet.event_type_code = C_EVENT_TYPE_CODE
17804: AND h1.event_id = xet.event_id

Line 18080: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

18076: l_balance_type_code VARCHAR2(1) :=NULL;
18077: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
18078:
18079: --
18080: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
18081: --
18082:
18083: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
18084: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 18165: , fnd_lookup_values fvl9

18161: , CST_XLA_INV_HEADERS_V h1
18162: , CST_XLA_INV_REF_V h3
18163: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
18164: , CST_XLA_INV_TXN_TYPES_REF_V h5
18165: , fnd_lookup_values fvl9
18166: , fnd_lookup_values fvl42
18167: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
18168: and xet.event_type_code = C_EVENT_TYPE_CODE
18169: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 18166: , fnd_lookup_values fvl42

18162: , CST_XLA_INV_REF_V h3
18163: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
18164: , CST_XLA_INV_TXN_TYPES_REF_V h5
18165: , fnd_lookup_values fvl9
18166: , fnd_lookup_values fvl42
18167: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
18168: and xet.event_type_code = C_EVENT_TYPE_CODE
18169: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
18170: AND h3.ref_transaction_id = h1.transaction_id AND h4.INVENTORY_ITEM_ID = h1.INVENTORY_ITEM_ID AND h4.ORGANIZATION_ID = h1.ORGANIZATION_ID AND h5.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 19115: , fnd_lookup_values fvl9

19111: , CST_XLA_INV_TXN_TYPES_REF_V h6
19112: , PO_REQ_DISTS_REF_V h7
19113: , PO_REQ_HEADERS_REF_V h8
19114: , PSA_CST_XLA_UPG_V h9
19115: , fnd_lookup_values fvl9
19116: , fnd_lookup_values fvl42
19117: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
19118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19119: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 19116: , fnd_lookup_values fvl42

19112: , PO_REQ_DISTS_REF_V h7
19113: , PO_REQ_HEADERS_REF_V h8
19114: , PSA_CST_XLA_UPG_V h9
19115: , fnd_lookup_values fvl9
19116: , fnd_lookup_values fvl42
19117: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
19118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19119: AND xet.event_type_code = C_EVENT_TYPE_CODE
19120: AND h1.event_id = xet.event_id

Line 19366: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

19362: l_balance_type_code VARCHAR2(1) :=NULL;
19363: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
19364:
19365: --
19366: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
19367: --
19368:
19369: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
19370: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 19482: , fnd_lookup_values fvl9

19478: , CST_XLA_INV_TXN_TYPES_REF_V h6
19479: , PO_REQ_DISTS_REF_V h7
19480: , PO_REQ_HEADERS_REF_V h8
19481: , PSA_CST_XLA_UPG_V h9
19482: , fnd_lookup_values fvl9
19483: , fnd_lookup_values fvl42
19484: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
19485: and xet.event_type_code = C_EVENT_TYPE_CODE
19486: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 19483: , fnd_lookup_values fvl42

19479: , PO_REQ_DISTS_REF_V h7
19480: , PO_REQ_HEADERS_REF_V h8
19481: , PSA_CST_XLA_UPG_V h9
19482: , fnd_lookup_values fvl9
19483: , fnd_lookup_values fvl42
19484: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
19485: and xet.event_type_code = C_EVENT_TYPE_CODE
19486: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
19487: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.BUS_FLOW_REQ_DIST_ID=h7.REQ_DISTRIBUTION_ID (+) AND h4.BUS_FLOW_REQ_ID = h8.REQ_ID (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 20455: , fnd_lookup_values fvl9

20451: , CST_XLA_INV_TXN_TYPES_REF_V h6
20452: , PO_REQ_DISTS_REF_V h7
20453: , PO_REQ_HEADERS_REF_V h8
20454: , PSA_CST_XLA_UPG_V h9
20455: , fnd_lookup_values fvl9
20456: , fnd_lookup_values fvl42
20457: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
20458: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20459: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 20456: , fnd_lookup_values fvl42

20452: , PO_REQ_DISTS_REF_V h7
20453: , PO_REQ_HEADERS_REF_V h8
20454: , PSA_CST_XLA_UPG_V h9
20455: , fnd_lookup_values fvl9
20456: , fnd_lookup_values fvl42
20457: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
20458: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20459: AND xet.event_type_code = C_EVENT_TYPE_CODE
20460: AND h1.event_id = xet.event_id

Line 20706: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

20702: l_balance_type_code VARCHAR2(1) :=NULL;
20703: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
20704:
20705: --
20706: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
20707: --
20708:
20709: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
20710: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 20822: , fnd_lookup_values fvl9

20818: , CST_XLA_INV_TXN_TYPES_REF_V h6
20819: , PO_REQ_DISTS_REF_V h7
20820: , PO_REQ_HEADERS_REF_V h8
20821: , PSA_CST_XLA_UPG_V h9
20822: , fnd_lookup_values fvl9
20823: , fnd_lookup_values fvl42
20824: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
20825: and xet.event_type_code = C_EVENT_TYPE_CODE
20826: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 20823: , fnd_lookup_values fvl42

20819: , PO_REQ_DISTS_REF_V h7
20820: , PO_REQ_HEADERS_REF_V h8
20821: , PSA_CST_XLA_UPG_V h9
20822: , fnd_lookup_values fvl9
20823: , fnd_lookup_values fvl42
20824: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
20825: and xet.event_type_code = C_EVENT_TYPE_CODE
20826: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
20827: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.BUS_FLOW_REQ_DIST_ID=h7.REQ_DISTRIBUTION_ID (+) AND h4.BUS_FLOW_REQ_ID = h8.REQ_ID (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 21698: , fnd_lookup_values fvl9

21694: ELSE null
21695: END source_meaning
21696: FROM xla_events_gt xet
21697: , CST_XLA_INV_HEADERS_V h1
21698: , fnd_lookup_values fvl9
21699: , fnd_lookup_values fvl42
21700: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
21701: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21702: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 21699: , fnd_lookup_values fvl42

21695: END source_meaning
21696: FROM xla_events_gt xet
21697: , CST_XLA_INV_HEADERS_V h1
21698: , fnd_lookup_values fvl9
21699: , fnd_lookup_values fvl42
21700: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
21701: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21702: AND xet.event_type_code = C_EVENT_TYPE_CODE
21703: AND h1.event_id = xet.event_id

Line 21979: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

21975: l_balance_type_code VARCHAR2(1) :=NULL;
21976: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
21977:
21978: --
21979: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
21980: --
21981:
21982: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21983: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 22046: , fnd_lookup_values fvl9

22042: , h1.TRANSFER_TO_GL_INDICATOR source_42
22043: , fvl42.meaning source_42_meaning
22044: FROM xla_events_gt xet
22045: , CST_XLA_INV_HEADERS_V h1
22046: , fnd_lookup_values fvl9
22047: , fnd_lookup_values fvl42
22048: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
22049: and xet.event_type_code = C_EVENT_TYPE_CODE
22050: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 22047: , fnd_lookup_values fvl42

22043: , fvl42.meaning source_42_meaning
22044: FROM xla_events_gt xet
22045: , CST_XLA_INV_HEADERS_V h1
22046: , fnd_lookup_values fvl9
22047: , fnd_lookup_values fvl42
22048: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
22049: and xet.event_type_code = C_EVENT_TYPE_CODE
22050: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
22051: AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 22876: , fnd_lookup_values fvl9

22872: ELSE null
22873: END source_meaning
22874: FROM xla_events_gt xet
22875: , CST_XLA_INV_HEADERS_V h1
22876: , fnd_lookup_values fvl9
22877: , fnd_lookup_values fvl42
22878: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
22879: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22880: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 22877: , fnd_lookup_values fvl42

22873: END source_meaning
22874: FROM xla_events_gt xet
22875: , CST_XLA_INV_HEADERS_V h1
22876: , fnd_lookup_values fvl9
22877: , fnd_lookup_values fvl42
22878: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
22879: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22880: AND xet.event_type_code = C_EVENT_TYPE_CODE
22881: AND h1.event_id = xet.event_id

Line 23157: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

23153: l_balance_type_code VARCHAR2(1) :=NULL;
23154: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
23155:
23156: --
23157: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
23158: --
23159:
23160: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23161: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 23224: , fnd_lookup_values fvl9

23220: , h1.TRANSFER_TO_GL_INDICATOR source_42
23221: , fvl42.meaning source_42_meaning
23222: FROM xla_events_gt xet
23223: , CST_XLA_INV_HEADERS_V h1
23224: , fnd_lookup_values fvl9
23225: , fnd_lookup_values fvl42
23226: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
23227: and xet.event_type_code = C_EVENT_TYPE_CODE
23228: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 23225: , fnd_lookup_values fvl42

23221: , fvl42.meaning source_42_meaning
23222: FROM xla_events_gt xet
23223: , CST_XLA_INV_HEADERS_V h1
23224: , fnd_lookup_values fvl9
23225: , fnd_lookup_values fvl42
23226: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
23227: and xet.event_type_code = C_EVENT_TYPE_CODE
23228: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
23229: AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 24082: , fnd_lookup_values fvl9

24078: , CST_XLA_INV_HEADERS_V h1
24079: , CST_XLA_INV_REF_V h3
24080: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24081: , CST_XLA_INV_TXN_TYPES_REF_V h5
24082: , fnd_lookup_values fvl9
24083: , fnd_lookup_values fvl42
24084: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
24085: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
24086: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 24083: , fnd_lookup_values fvl42

24079: , CST_XLA_INV_REF_V h3
24080: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24081: , CST_XLA_INV_TXN_TYPES_REF_V h5
24082: , fnd_lookup_values fvl9
24083: , fnd_lookup_values fvl42
24084: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
24085: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
24086: AND xet.event_type_code = C_EVENT_TYPE_CODE
24087: AND h1.event_id = xet.event_id

Line 24363: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

24359: l_balance_type_code VARCHAR2(1) :=NULL;
24360: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
24361:
24362: --
24363: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
24364: --
24365:
24366: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
24367: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 24448: , fnd_lookup_values fvl9

24444: , CST_XLA_INV_HEADERS_V h1
24445: , CST_XLA_INV_REF_V h3
24446: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24447: , CST_XLA_INV_TXN_TYPES_REF_V h5
24448: , fnd_lookup_values fvl9
24449: , fnd_lookup_values fvl42
24450: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
24451: and xet.event_type_code = C_EVENT_TYPE_CODE
24452: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 24449: , fnd_lookup_values fvl42

24445: , CST_XLA_INV_REF_V h3
24446: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24447: , CST_XLA_INV_TXN_TYPES_REF_V h5
24448: , fnd_lookup_values fvl9
24449: , fnd_lookup_values fvl42
24450: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
24451: and xet.event_type_code = C_EVENT_TYPE_CODE
24452: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
24453: AND h3.ref_transaction_id = h1.transaction_id AND h4.INVENTORY_ITEM_ID = h1.INVENTORY_ITEM_ID AND h4.ORGANIZATION_ID = h1.ORGANIZATION_ID AND h5.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 25329: , fnd_lookup_values fvl9

25325: , CST_XLA_INV_HEADERS_V h1
25326: , CST_XLA_INV_REF_V h3
25327: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25328: , CST_XLA_INV_TXN_TYPES_REF_V h5
25329: , fnd_lookup_values fvl9
25330: , fnd_lookup_values fvl42
25331: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
25332: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25333: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 25330: , fnd_lookup_values fvl42

25326: , CST_XLA_INV_REF_V h3
25327: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25328: , CST_XLA_INV_TXN_TYPES_REF_V h5
25329: , fnd_lookup_values fvl9
25330: , fnd_lookup_values fvl42
25331: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
25332: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25333: AND xet.event_type_code = C_EVENT_TYPE_CODE
25334: AND h1.event_id = xet.event_id

Line 25610: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

25606: l_balance_type_code VARCHAR2(1) :=NULL;
25607: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
25608:
25609: --
25610: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
25611: --
25612:
25613: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
25614: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 25695: , fnd_lookup_values fvl9

25691: , CST_XLA_INV_HEADERS_V h1
25692: , CST_XLA_INV_REF_V h3
25693: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25694: , CST_XLA_INV_TXN_TYPES_REF_V h5
25695: , fnd_lookup_values fvl9
25696: , fnd_lookup_values fvl42
25697: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
25698: and xet.event_type_code = C_EVENT_TYPE_CODE
25699: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 25696: , fnd_lookup_values fvl42

25692: , CST_XLA_INV_REF_V h3
25693: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25694: , CST_XLA_INV_TXN_TYPES_REF_V h5
25695: , fnd_lookup_values fvl9
25696: , fnd_lookup_values fvl42
25697: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
25698: and xet.event_type_code = C_EVENT_TYPE_CODE
25699: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
25700: AND h3.ref_transaction_id = h1.transaction_id AND h4.INVENTORY_ITEM_ID = h1.INVENTORY_ITEM_ID AND h4.ORGANIZATION_ID = h1.ORGANIZATION_ID AND h5.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 26645: , fnd_lookup_values fvl9

26641: , CST_XLA_INV_TXN_TYPES_REF_V h6
26642: , PO_DISTS_REF_V h7
26643: , PO_HEADERS_REF_V h8
26644: , PSA_CST_XLA_UPG_V h9
26645: , fnd_lookup_values fvl9
26646: , fnd_lookup_values fvl42
26647: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
26648: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26649: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 26646: , fnd_lookup_values fvl42

26642: , PO_DISTS_REF_V h7
26643: , PO_HEADERS_REF_V h8
26644: , PSA_CST_XLA_UPG_V h9
26645: , fnd_lookup_values fvl9
26646: , fnd_lookup_values fvl42
26647: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
26648: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26649: AND xet.event_type_code = C_EVENT_TYPE_CODE
26650: AND h1.event_id = xet.event_id

Line 26897: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

26893: l_balance_type_code VARCHAR2(1) :=NULL;
26894: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
26895:
26896: --
26897: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
26898: --
26899:
26900: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
26901: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 27013: , fnd_lookup_values fvl9

27009: , CST_XLA_INV_TXN_TYPES_REF_V h6
27010: , PO_DISTS_REF_V h7
27011: , PO_HEADERS_REF_V h8
27012: , PSA_CST_XLA_UPG_V h9
27013: , fnd_lookup_values fvl9
27014: , fnd_lookup_values fvl42
27015: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
27016: and xet.event_type_code = C_EVENT_TYPE_CODE
27017: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 27014: , fnd_lookup_values fvl42

27010: , PO_DISTS_REF_V h7
27011: , PO_HEADERS_REF_V h8
27012: , PSA_CST_XLA_UPG_V h9
27013: , fnd_lookup_values fvl9
27014: , fnd_lookup_values fvl42
27015: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
27016: and xet.event_type_code = C_EVENT_TYPE_CODE
27017: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
27018: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID (+) = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.txn_po_header_id = h7.po_header_id (+) AND h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

Line 28021: , fnd_lookup_values fvl9

28017: , CST_XLA_INV_TXN_TYPES_REF_V h6
28018: , PO_DISTS_REF_V h7
28019: , PO_HEADERS_REF_V h8
28020: , PSA_CST_XLA_UPG_V h9
28021: , fnd_lookup_values fvl9
28022: , fnd_lookup_values fvl42
28023: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
28024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28025: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 28022: , fnd_lookup_values fvl42

28018: , PO_DISTS_REF_V h7
28019: , PO_HEADERS_REF_V h8
28020: , PSA_CST_XLA_UPG_V h9
28021: , fnd_lookup_values fvl9
28022: , fnd_lookup_values fvl42
28023: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
28024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28025: AND xet.event_type_code = C_EVENT_TYPE_CODE
28026: AND h1.event_id = xet.event_id

Line 28273: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

28269: l_balance_type_code VARCHAR2(1) :=NULL;
28270: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
28271:
28272: --
28273: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
28274: --
28275:
28276: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
28277: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 28389: , fnd_lookup_values fvl9

28385: , CST_XLA_INV_TXN_TYPES_REF_V h6
28386: , PO_DISTS_REF_V h7
28387: , PO_HEADERS_REF_V h8
28388: , PSA_CST_XLA_UPG_V h9
28389: , fnd_lookup_values fvl9
28390: , fnd_lookup_values fvl42
28391: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
28392: and xet.event_type_code = C_EVENT_TYPE_CODE
28393: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 28390: , fnd_lookup_values fvl42

28386: , PO_DISTS_REF_V h7
28387: , PO_HEADERS_REF_V h8
28388: , PSA_CST_XLA_UPG_V h9
28389: , fnd_lookup_values fvl9
28390: , fnd_lookup_values fvl42
28391: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
28392: and xet.event_type_code = C_EVENT_TYPE_CODE
28393: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
28394: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID (+) = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.txn_po_header_id = h7.po_header_id (+) AND h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

Line 29397: , fnd_lookup_values fvl9

29393: , CST_XLA_INV_TXN_TYPES_REF_V h6
29394: , PO_DISTS_REF_V h7
29395: , PO_HEADERS_REF_V h8
29396: , PSA_CST_XLA_UPG_V h9
29397: , fnd_lookup_values fvl9
29398: , fnd_lookup_values fvl42
29399: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
29400: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29401: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 29398: , fnd_lookup_values fvl42

29394: , PO_DISTS_REF_V h7
29395: , PO_HEADERS_REF_V h8
29396: , PSA_CST_XLA_UPG_V h9
29397: , fnd_lookup_values fvl9
29398: , fnd_lookup_values fvl42
29399: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
29400: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29401: AND xet.event_type_code = C_EVENT_TYPE_CODE
29402: AND h1.event_id = xet.event_id

Line 29649: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

29645: l_balance_type_code VARCHAR2(1) :=NULL;
29646: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
29647:
29648: --
29649: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
29650: --
29651:
29652: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
29653: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 29765: , fnd_lookup_values fvl9

29761: , CST_XLA_INV_TXN_TYPES_REF_V h6
29762: , PO_DISTS_REF_V h7
29763: , PO_HEADERS_REF_V h8
29764: , PSA_CST_XLA_UPG_V h9
29765: , fnd_lookup_values fvl9
29766: , fnd_lookup_values fvl42
29767: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
29768: and xet.event_type_code = C_EVENT_TYPE_CODE
29769: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 29766: , fnd_lookup_values fvl42

29762: , PO_DISTS_REF_V h7
29763: , PO_HEADERS_REF_V h8
29764: , PSA_CST_XLA_UPG_V h9
29765: , fnd_lookup_values fvl9
29766: , fnd_lookup_values fvl42
29767: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
29768: and xet.event_type_code = C_EVENT_TYPE_CODE
29769: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
29770: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID (+) = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.txn_po_header_id = h7.po_header_id (+) AND h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

Line 30740: , fnd_lookup_values fvl9

30736: , CST_XLA_RCV_REF_V h3
30737: , PO_DISTS_REF_V h4
30738: , PO_HEADERS_REF_V h5
30739: , PSA_CST_XLA_PEA_UPG_V h6
30740: , fnd_lookup_values fvl9
30741: , fnd_lookup_values fvl42
30742: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
30743: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30744: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 30741: , fnd_lookup_values fvl42

30737: , PO_DISTS_REF_V h4
30738: , PO_HEADERS_REF_V h5
30739: , PSA_CST_XLA_PEA_UPG_V h6
30740: , fnd_lookup_values fvl9
30741: , fnd_lookup_values fvl42
30742: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
30743: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30744: AND xet.event_class_code = C_EVENT_CLASS_CODE
30745: AND h1.event_id = xet.event_id

Line 30987: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

30983: l_balance_type_code VARCHAR2(1) :=NULL;
30984: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
30985:
30986: --
30987: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
30988: --
30989:
30990: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
30991: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 31079: , fnd_lookup_values fvl9

31075: , CST_XLA_RCV_REF_V h3
31076: , PO_DISTS_REF_V h4
31077: , PO_HEADERS_REF_V h5
31078: , PSA_CST_XLA_PEA_UPG_V h6
31079: , fnd_lookup_values fvl9
31080: , fnd_lookup_values fvl42
31081: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
31082: and xet.event_class_code = C_EVENT_CLASS_CODE
31083: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 31080: , fnd_lookup_values fvl42

31076: , PO_DISTS_REF_V h4
31077: , PO_HEADERS_REF_V h5
31078: , PSA_CST_XLA_PEA_UPG_V h6
31079: , fnd_lookup_values fvl9
31080: , fnd_lookup_values fvl42
31081: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
31082: and xet.event_class_code = C_EVENT_CLASS_CODE
31083: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
31084: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h4.po_header_id (+) AND h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.ref_rcv_accounting_event_id = h6.accounting_event_id (+) AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 32069: , fnd_lookup_values fvl9

32065: , CST_XLA_INV_TXN_TYPES_REF_V h6
32066: , PO_DISTS_REF_V h7
32067: , PO_HEADERS_REF_V h8
32068: , PSA_CST_XLA_UPG_V h9
32069: , fnd_lookup_values fvl9
32070: , fnd_lookup_values fvl42
32071: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
32072: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
32073: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 32070: , fnd_lookup_values fvl42

32066: , PO_DISTS_REF_V h7
32067: , PO_HEADERS_REF_V h8
32068: , PSA_CST_XLA_UPG_V h9
32069: , fnd_lookup_values fvl9
32070: , fnd_lookup_values fvl42
32071: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
32072: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
32073: AND xet.event_type_code = C_EVENT_TYPE_CODE
32074: AND h1.event_id = xet.event_id

Line 32321: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

32317: l_balance_type_code VARCHAR2(1) :=NULL;
32318: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
32319:
32320: --
32321: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
32322: --
32323:
32324: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
32325: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 32437: , fnd_lookup_values fvl9

32433: , CST_XLA_INV_TXN_TYPES_REF_V h6
32434: , PO_DISTS_REF_V h7
32435: , PO_HEADERS_REF_V h8
32436: , PSA_CST_XLA_UPG_V h9
32437: , fnd_lookup_values fvl9
32438: , fnd_lookup_values fvl42
32439: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
32440: and xet.event_type_code = C_EVENT_TYPE_CODE
32441: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 32438: , fnd_lookup_values fvl42

32434: , PO_DISTS_REF_V h7
32435: , PO_HEADERS_REF_V h8
32436: , PSA_CST_XLA_UPG_V h9
32437: , fnd_lookup_values fvl9
32438: , fnd_lookup_values fvl42
32439: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
32440: and xet.event_type_code = C_EVENT_TYPE_CODE
32441: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
32442: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID (+) = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.txn_po_header_id = h7.po_header_id (+) AND h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

Line 33445: , fnd_lookup_values fvl9

33441: , CST_XLA_INV_TXN_TYPES_REF_V h6
33442: , PO_DISTS_REF_V h7
33443: , PO_HEADERS_REF_V h8
33444: , PSA_CST_XLA_UPG_V h9
33445: , fnd_lookup_values fvl9
33446: , fnd_lookup_values fvl42
33447: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
33448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
33449: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 33446: , fnd_lookup_values fvl42

33442: , PO_DISTS_REF_V h7
33443: , PO_HEADERS_REF_V h8
33444: , PSA_CST_XLA_UPG_V h9
33445: , fnd_lookup_values fvl9
33446: , fnd_lookup_values fvl42
33447: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
33448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
33449: AND xet.event_type_code = C_EVENT_TYPE_CODE
33450: AND h1.event_id = xet.event_id

Line 33697: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

33693: l_balance_type_code VARCHAR2(1) :=NULL;
33694: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
33695:
33696: --
33697: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
33698: --
33699:
33700: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
33701: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 33813: , fnd_lookup_values fvl9

33809: , CST_XLA_INV_TXN_TYPES_REF_V h6
33810: , PO_DISTS_REF_V h7
33811: , PO_HEADERS_REF_V h8
33812: , PSA_CST_XLA_UPG_V h9
33813: , fnd_lookup_values fvl9
33814: , fnd_lookup_values fvl42
33815: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
33816: and xet.event_type_code = C_EVENT_TYPE_CODE
33817: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 33814: , fnd_lookup_values fvl42

33810: , PO_DISTS_REF_V h7
33811: , PO_HEADERS_REF_V h8
33812: , PSA_CST_XLA_UPG_V h9
33813: , fnd_lookup_values fvl9
33814: , fnd_lookup_values fvl42
33815: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
33816: and xet.event_type_code = C_EVENT_TYPE_CODE
33817: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
33818: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID (+) = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.txn_po_header_id = h7.po_header_id (+) AND h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

Line 34821: , fnd_lookup_values fvl9

34817: , CST_XLA_INV_TXN_TYPES_REF_V h6
34818: , PO_DISTS_REF_V h7
34819: , PO_HEADERS_REF_V h8
34820: , PSA_CST_XLA_UPG_V h9
34821: , fnd_lookup_values fvl9
34822: , fnd_lookup_values fvl42
34823: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
34824: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
34825: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 34822: , fnd_lookup_values fvl42

34818: , PO_DISTS_REF_V h7
34819: , PO_HEADERS_REF_V h8
34820: , PSA_CST_XLA_UPG_V h9
34821: , fnd_lookup_values fvl9
34822: , fnd_lookup_values fvl42
34823: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
34824: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
34825: AND xet.event_type_code = C_EVENT_TYPE_CODE
34826: AND h1.event_id = xet.event_id

Line 35073: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

35069: l_balance_type_code VARCHAR2(1) :=NULL;
35070: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
35071:
35072: --
35073: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
35074: --
35075:
35076: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
35077: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 35189: , fnd_lookup_values fvl9

35185: , CST_XLA_INV_TXN_TYPES_REF_V h6
35186: , PO_DISTS_REF_V h7
35187: , PO_HEADERS_REF_V h8
35188: , PSA_CST_XLA_UPG_V h9
35189: , fnd_lookup_values fvl9
35190: , fnd_lookup_values fvl42
35191: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
35192: and xet.event_type_code = C_EVENT_TYPE_CODE
35193: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 35190: , fnd_lookup_values fvl42

35186: , PO_DISTS_REF_V h7
35187: , PO_HEADERS_REF_V h8
35188: , PSA_CST_XLA_UPG_V h9
35189: , fnd_lookup_values fvl9
35190: , fnd_lookup_values fvl42
35191: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
35192: and xet.event_type_code = C_EVENT_TYPE_CODE
35193: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
35194: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h5.INVENTORY_ITEM_ID (+) = h1.INVENTORY_ITEM_ID AND h5.ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h6.INV_TRANSACTION_TYPE_ID = h1.TRANSACTION_TYPE_ID AND h4.txn_po_header_id = h7.po_header_id (+) AND h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =