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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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'
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
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
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;
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
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(+) =
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
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
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;
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
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(+) =
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
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
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;
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
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(+) =
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
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
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;
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
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'
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
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
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;
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
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(+) =
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
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
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;
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
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(+) =
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
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
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;
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
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(+) =