eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00707_AAD_S_000019_PKG dependencies on ALL_OBJECTS

Line 305210: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

305206: , CST_XLA_WIP_HEADERS_V h1
305207: , fnd_lookup_values fvl7
305208: , fnd_lookup_values fvl85
305209: , fnd_lookup_values fvl114
305210: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
305211: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
305212: AND xet.event_class_code = C_EVENT_CLASS_CODE
305213: AND h1.event_id = xet.event_id
305214: AND fvl7.lookup_type(+) = 'WIP_TRANSACTION_TYPE'

Line 305340: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

305336: END source_value
305337: , null source_meaning
305338: FROM xla_events_gt xet
305339: , CST_XLA_WIP_LINES_V l2
305340: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
305341: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
305342: AND xet.event_class_code = C_EVENT_CLASS_CODE
305343: AND l2.event_id = xet.event_id
305344:

Line 306554: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

306550: FROM xla_events_gt xet
306551: , CST_XLA_AWO_HEADERS_V h1
306552: , fnd_lookup_values fvl85
306553: , fnd_lookup_values fvl114
306554: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
306555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
306556: AND xet.event_class_code = C_EVENT_CLASS_CODE
306557: AND h1.event_id = xet.event_id
306558: AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 306690: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

306686: END source_value
306687: , null source_meaning
306688: FROM xla_events_gt xet
306689: , CST_XLA_AWO_LINES_V l2
306690: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
306691: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
306692: AND xet.event_class_code = C_EVENT_CLASS_CODE
306693: AND l2.event_id = xet.event_id
306694:

Line 307883: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

307879: , CST_XLA_PLA_CATEGORY_REF_V h7
307880: , fnd_lookup_values fvl39
307881: , fnd_lookup_values fvl85
307882: , fnd_lookup_values fvl114
307883: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
307884: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
307885: AND xet.event_type_code = C_EVENT_TYPE_CODE
307886: AND h1.event_id = xet.event_id
307887: 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 h7.pla_cat_organization_id (+) = h1.organization_id

Line 308053: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

308049: ELSE null
308050: END source_meaning
308051: FROM xla_events_gt xet
308052: , CST_XLA_INV_LINES_V l2
308053: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
308054: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
308055: AND xet.event_type_code = C_EVENT_TYPE_CODE
308056: AND l2.event_id = xet.event_id
308057:

Line 309361: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

309357: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
309358: , CST_XLA_INV_TXN_TYPES_REF_V h5
309359: , fnd_lookup_values fvl85
309360: , fnd_lookup_values fvl114
309361: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
309362: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
309363: AND xet.event_type_code = C_EVENT_TYPE_CODE
309364: AND h1.event_id = xet.event_id
309365: 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 fvl85.lookup_type(+) =

Line 309512: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

309508: END source_value
309509: , null source_meaning
309510: FROM xla_events_gt xet
309511: , CST_XLA_INV_LINES_V l2
309512: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
309513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
309514: AND xet.event_type_code = C_EVENT_TYPE_CODE
309515: AND l2.event_id = xet.event_id
309516:

Line 310736: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

310732: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
310733: , CST_XLA_INV_TXN_TYPES_REF_V h5
310734: , fnd_lookup_values fvl85
310735: , fnd_lookup_values fvl114
310736: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
310737: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
310738: AND xet.event_type_code = C_EVENT_TYPE_CODE
310739: AND h1.event_id = xet.event_id
310740: 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 fvl85.lookup_type(+) =

Line 310887: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

310883: END source_value
310884: , null source_meaning
310885: FROM xla_events_gt xet
310886: , CST_XLA_INV_LINES_V l2
310887: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
310888: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
310889: AND xet.event_type_code = C_EVENT_TYPE_CODE
310890: AND l2.event_id = xet.event_id
310891:

Line 312163: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

312159: , CST_XLA_INV_TXN_TYPES_REF_V h6
312160: , CST_XLA_PLA_CATEGORY_REF_V h7
312161: , fnd_lookup_values fvl85
312162: , fnd_lookup_values fvl114
312163: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
312164: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
312165: AND xet.event_class_code = C_EVENT_CLASS_CODE
312166: AND h1.event_id = xet.event_id
312167: 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 h7.pla_cat_organization_id (+) = h1.organization_id

Line 312330: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

312326: ELSE null
312327: END source_meaning
312328: FROM xla_events_gt xet
312329: , CST_XLA_INV_LINES_V l2
312330: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
312331: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
312332: AND xet.event_class_code = C_EVENT_CLASS_CODE
312333: AND l2.event_id = xet.event_id
312334:

Line 313756: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

313752: , PO_HEADERS_REF_V h5
313753: , PSA_CST_XLA_UPG_V h6
313754: , fnd_lookup_values fvl85
313755: , fnd_lookup_values fvl114
313756: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
313757: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
313758: AND xet.event_class_code = C_EVENT_CLASS_CODE
313759: AND h1.event_id = xet.event_id
313760: 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 fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 313882: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

313878: END source_value
313879: , null source_meaning
313880: FROM xla_events_gt xet
313881: , CST_XLA_RCV_LINES_V l2
313882: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
313883: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
313884: AND xet.event_class_code = C_EVENT_CLASS_CODE
313885: AND l2.event_id = xet.event_id
313886:

Line 315151: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)

315147: , PO_REQ_HEADERS_REF_V h9
315148: , PSA_CST_XLA_UPG_V h10
315149: , fnd_lookup_values fvl85
315150: , fnd_lookup_values fvl114
315151: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
315152: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
315153: AND xet.event_class_code = C_EVENT_CLASS_CODE
315154: AND h2.event_id = xet.event_id
315155: AND h1.event_id (+) = h2.event_id

Line 315320: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

315316: ELSE null
315317: END source_meaning
315318: FROM xla_events_gt xet
315319: , CST_XLA_INV_LINES_V l3
315320: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
315321: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
315322: AND xet.event_class_code = C_EVENT_CLASS_CODE
315323: AND l3.event_id = xet.event_id
315324:

Line 317048: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

317044: , CST_XLA_INV_TXN_TYPES_REF_V h6
317045: , CST_XLA_PLA_CATEGORY_REF_V h7
317046: , fnd_lookup_values fvl85
317047: , fnd_lookup_values fvl114
317048: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
317049: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
317050: AND xet.event_class_code = C_EVENT_CLASS_CODE
317051: AND h2.event_id = xet.event_id
317052: AND h1.event_id (+) = h2.event_id

Line 317216: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

317212: ELSE null
317213: END source_meaning
317214: FROM xla_events_gt xet
317215: , CST_XLA_INV_LINES_V l3
317216: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
317217: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
317218: AND xet.event_class_code = C_EVENT_CLASS_CODE
317219: AND l3.event_id = xet.event_id
317220:

Line 318772: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

318768: , fnd_lookup_values fvl7
318769: , fnd_lookup_values fvl55
318770: , fnd_lookup_values fvl85
318771: , fnd_lookup_values fvl114
318772: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
318773: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
318774: AND xet.event_type_code = C_EVENT_TYPE_CODE
318775: AND h6.event_id = xet.event_id
318776: AND h1.dis_job_wip_entity_id (+) = h6.wip_entity_id AND h2.flo_sch_wip_entity_id (+) = h6.wip_entity_id AND h3.inventory_item_id (+) = h6.inventory_item_id and h3.organization_id (+) = h6.organization_id AND h4.rep_itm_wip_entity_id (+) = h6.wip_entity_id and h4.rep_itm_line_id (+) = h6.line_id AND h5.wip_entity_id = h6.wip_entity_id AND fvl7.lookup_type(+) = 'WIP_TRANSACTION_TYPE'

Line 318905: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

318901: END source_value
318902: , null source_meaning
318903: FROM xla_events_gt xet
318904: , CST_XLA_WIP_LINES_V l7
318905: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
318906: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
318907: AND xet.event_type_code = C_EVENT_TYPE_CODE
318908: AND l7.event_id = xet.event_id
318909:

Line 320256: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

320252: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
320253: , CST_XLA_INV_TXN_TYPES_REF_V h6
320254: , fnd_lookup_values fvl85
320255: , fnd_lookup_values fvl114
320256: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
320257: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
320258: AND xet.event_type_code = C_EVENT_TYPE_CODE
320259: AND h2.event_id = xet.event_id
320260: AND h1.event_id (+) = h2.event_id

Line 320408: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

320404: END source_value
320405: , null source_meaning
320406: FROM xla_events_gt xet
320407: , CST_XLA_INV_LINES_V l3
320408: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
320409: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
320410: AND xet.event_type_code = C_EVENT_TYPE_CODE
320411: AND l3.event_id = xet.event_id
320412:

Line 321706: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

321702: , CST_XLA_INV_TXN_TYPES_REF_V h6
321703: , CST_XLA_PLA_CATEGORY_REF_V h7
321704: , fnd_lookup_values fvl85
321705: , fnd_lookup_values fvl114
321706: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
321707: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
321708: AND xet.event_type_code = C_EVENT_TYPE_CODE
321709: AND h2.event_id = xet.event_id
321710: AND h1.event_id (+) = h2.event_id

Line 321873: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

321869: ELSE null
321870: END source_meaning
321871: FROM xla_events_gt xet
321872: , CST_XLA_INV_LINES_V l3
321873: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
321874: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
321875: AND xet.event_type_code = C_EVENT_TYPE_CODE
321876: AND l3.event_id = xet.event_id
321877:

Line 323270: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)

323266: , PO_REQ_HEADERS_REF_V h9
323267: , PSA_CST_XLA_UPG_V h10
323268: , fnd_lookup_values fvl85
323269: , fnd_lookup_values fvl114
323270: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
323271: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
323272: AND xet.event_type_code = C_EVENT_TYPE_CODE
323273: AND h2.event_id = xet.event_id
323274: AND h1.event_id (+) = h2.event_id

Line 323438: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

323434: ELSE null
323435: END source_meaning
323436: FROM xla_events_gt xet
323437: , CST_XLA_INV_LINES_V l3
323438: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
323439: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
323440: AND xet.event_type_code = C_EVENT_TYPE_CODE
323441: AND l3.event_id = xet.event_id
323442:

Line 325176: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)

325172: , PO_REQ_HEADERS_REF_V h9
325173: , PSA_CST_XLA_UPG_V h10
325174: , fnd_lookup_values fvl85
325175: , fnd_lookup_values fvl114
325176: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
325177: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
325178: AND xet.event_type_code = C_EVENT_TYPE_CODE
325179: AND h2.event_id = xet.event_id
325180: AND h1.event_id (+) = h2.event_id

Line 325344: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

325340: ELSE null
325341: END source_meaning
325342: FROM xla_events_gt xet
325343: , CST_XLA_INV_LINES_V l3
325344: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
325345: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
325346: AND xet.event_type_code = C_EVENT_TYPE_CODE
325347: AND l3.event_id = xet.event_id
325348:

Line 327042: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

327038: , CST_XLA_PLA_CATEGORY_REF_V h8
327039: , fnd_lookup_values fvl39
327040: , fnd_lookup_values fvl85
327041: , fnd_lookup_values fvl114
327042: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
327043: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
327044: AND xet.event_type_code = C_EVENT_TYPE_CODE
327045: AND h2.event_id = xet.event_id
327046: AND h1.event_id (+) = h2.event_id

Line 327208: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

327204: ELSE null
327205: END source_meaning
327206: FROM xla_events_gt xet
327207: , CST_XLA_INV_LINES_V l3
327208: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
327209: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
327210: AND xet.event_type_code = C_EVENT_TYPE_CODE
327211: AND l3.event_id = xet.event_id
327212:

Line 328719: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

328715: , CST_XLA_PLA_CATEGORY_REF_V h8
328716: , fnd_lookup_values fvl39
328717: , fnd_lookup_values fvl85
328718: , fnd_lookup_values fvl114
328719: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
328720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
328721: AND xet.event_type_code = C_EVENT_TYPE_CODE
328722: AND h2.event_id = xet.event_id
328723: AND h1.event_id (+) = h2.event_id

Line 328885: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

328881: ELSE null
328882: END source_meaning
328883: FROM xla_events_gt xet
328884: , CST_XLA_INV_LINES_V l3
328885: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
328886: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
328887: AND xet.event_type_code = C_EVENT_TYPE_CODE
328888: AND l3.event_id = xet.event_id
328889:

Line 330279: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

330275: , CST_XLA_PLA_CATEGORY_REF_V h8
330276: , fnd_lookup_values fvl39
330277: , fnd_lookup_values fvl85
330278: , fnd_lookup_values fvl114
330279: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
330280: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
330281: AND xet.event_type_code = C_EVENT_TYPE_CODE
330282: AND h2.event_id = xet.event_id
330283: AND h1.event_id (+) = h2.event_id

Line 330450: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

330446: ELSE null
330447: END source_meaning
330448: FROM xla_events_gt xet
330449: , CST_XLA_INV_LINES_V l3
330450: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
330451: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
330452: AND xet.event_type_code = C_EVENT_TYPE_CODE
330453: AND l3.event_id = xet.event_id
330454:

Line 331868: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

331864: , PSA_CST_XLA_UPG_V h11
331865: , fnd_lookup_values fvl39
331866: , fnd_lookup_values fvl85
331867: , fnd_lookup_values fvl114
331868: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
331869: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
331870: AND xet.event_type_code = C_EVENT_TYPE_CODE
331871: AND h2.event_id = xet.event_id
331872: AND h1.event_id (+) = h2.event_id

Line 332040: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

332036: ELSE null
332037: END source_meaning
332038: FROM xla_events_gt xet
332039: , CST_XLA_INV_LINES_V l3
332040: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
332041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
332042: AND xet.event_type_code = C_EVENT_TYPE_CODE
332043: AND l3.event_id = xet.event_id
332044:

Line 333526: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

333522: , CST_XLA_PLA_CATEGORY_REF_V h8
333523: , fnd_lookup_values fvl39
333524: , fnd_lookup_values fvl85
333525: , fnd_lookup_values fvl114
333526: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
333527: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
333528: AND xet.event_type_code = C_EVENT_TYPE_CODE
333529: AND h2.event_id = xet.event_id
333530: AND h1.event_id (+) = h2.event_id

Line 333692: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

333688: ELSE null
333689: END source_meaning
333690: FROM xla_events_gt xet
333691: , CST_XLA_INV_LINES_V l3
333692: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
333693: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
333694: AND xet.event_type_code = C_EVENT_TYPE_CODE
333695: AND l3.event_id = xet.event_id
333696:

Line 335281: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

335277: , CST_XLA_PLA_CATEGORY_REF_V h8
335278: , fnd_lookup_values fvl39
335279: , fnd_lookup_values fvl85
335280: , fnd_lookup_values fvl114
335281: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
335282: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
335283: AND xet.event_type_code = C_EVENT_TYPE_CODE
335284: AND h2.event_id = xet.event_id
335285: AND h1.event_id (+) = h2.event_id

Line 335447: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

335443: ELSE null
335444: END source_meaning
335445: FROM xla_events_gt xet
335446: , CST_XLA_INV_LINES_V l3
335447: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
335448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
335449: AND xet.event_type_code = C_EVENT_TYPE_CODE
335450: AND l3.event_id = xet.event_id
335451:

Line 336995: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

336991: , CST_XLA_INV_HEADERS_V h2
336992: , CST_XLA_PLA_CATEGORY_REF_V h4
336993: , fnd_lookup_values fvl85
336994: , fnd_lookup_values fvl114
336995: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
336996: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
336997: AND xet.event_type_code = C_EVENT_TYPE_CODE
336998: AND h2.event_id = xet.event_id
336999: AND h1.event_id (+) = h2.event_id

Line 337162: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

337158: ELSE null
337159: END source_meaning
337160: FROM xla_events_gt xet
337161: , CST_XLA_INV_LINES_V l3
337162: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
337163: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
337164: AND xet.event_type_code = C_EVENT_TYPE_CODE
337165: AND l3.event_id = xet.event_id
337166:

Line 338532: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

338528: , CST_XLA_INV_TXN_TYPES_REF_V h6
338529: , CST_XLA_PLA_CATEGORY_REF_V h7
338530: , fnd_lookup_values fvl85
338531: , fnd_lookup_values fvl114
338532: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
338533: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
338534: AND xet.event_type_code = C_EVENT_TYPE_CODE
338535: AND h2.event_id = xet.event_id
338536: AND h1.event_id (+) = h2.event_id

Line 338694: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

338690: ELSE null
338691: END source_meaning
338692: FROM xla_events_gt xet
338693: , CST_XLA_INV_LINES_V l3
338694: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
338695: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
338696: AND xet.event_type_code = C_EVENT_TYPE_CODE
338697: AND l3.event_id = xet.event_id
338698:

Line 340037: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

340033: , CST_XLA_PLA_CATEGORY_REF_V h6
340034: , CST_XLA_TRF_PLA_CAT_REF_V h7
340035: , fnd_lookup_values fvl85
340036: , fnd_lookup_values fvl114
340037: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
340038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
340039: AND xet.event_class_code = C_EVENT_CLASS_CODE
340040: AND h1.event_id = xet.event_id
340041: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 340217: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

340213: ELSE null
340214: END source_meaning
340215: FROM xla_events_gt xet
340216: , CST_XLA_INV_LINES_V l2
340217: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
340218: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
340219: AND xet.event_class_code = C_EVENT_CLASS_CODE
340220: AND l2.event_id = xet.event_id
340221:

Line 341631: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

341627: , CST_XLA_INV_TXN_TYPES_REF_V h6
341628: , CST_XLA_PLA_CATEGORY_REF_V h7
341629: , fnd_lookup_values fvl85
341630: , fnd_lookup_values fvl114
341631: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
341632: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
341633: AND xet.event_type_code = C_EVENT_TYPE_CODE
341634: AND h2.event_id = xet.event_id
341635: AND h1.event_id (+) = h2.event_id

Line 341798: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

341794: ELSE null
341795: END source_meaning
341796: FROM xla_events_gt xet
341797: , CST_XLA_INV_LINES_V l3
341798: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
341799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
341800: AND xet.event_type_code = C_EVENT_TYPE_CODE
341801: AND l3.event_id = xet.event_id
341802:

Line 343246: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

343242: , CST_XLA_INV_TXN_TYPES_REF_V h6
343243: , CST_XLA_PLA_CATEGORY_REF_V h7
343244: , fnd_lookup_values fvl85
343245: , fnd_lookup_values fvl114
343246: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
343247: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
343248: AND xet.event_type_code = C_EVENT_TYPE_CODE
343249: AND h2.event_id = xet.event_id
343250: AND h1.event_id (+) = h2.event_id

Line 343413: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

343409: ELSE null
343410: END source_meaning
343411: FROM xla_events_gt xet
343412: , CST_XLA_INV_LINES_V l3
343413: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
343414: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
343415: AND xet.event_type_code = C_EVENT_TYPE_CODE
343416: AND l3.event_id = xet.event_id
343417:

Line 344838: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

344834: , fnd_lookup_values fvl7
344835: , fnd_lookup_values fvl55
344836: , fnd_lookup_values fvl85
344837: , fnd_lookup_values fvl114
344838: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
344839: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
344840: AND xet.event_type_code = C_EVENT_TYPE_CODE
344841: AND h6.event_id = xet.event_id
344842: AND h1.dis_job_wip_entity_id (+) = h6.wip_entity_id AND h2.flo_sch_wip_entity_id (+) = h6.wip_entity_id AND h3.inventory_item_id (+) = h6.inventory_item_id and h3.organization_id (+) = h6.organization_id AND h4.rep_itm_wip_entity_id (+) = h6.wip_entity_id and h4.rep_itm_line_id (+) = h6.line_id AND h5.wip_entity_id = h6.wip_entity_id AND fvl7.lookup_type(+) = 'WIP_TRANSACTION_TYPE'

Line 344971: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

344967: END source_value
344968: , null source_meaning
344969: FROM xla_events_gt xet
344970: , CST_XLA_WIP_LINES_V l7
344971: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
344972: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
344973: AND xet.event_type_code = C_EVENT_TYPE_CODE
344974: AND l7.event_id = xet.event_id
344975:

Line 346345: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

346341: , CST_XLA_PLA_CATEGORY_REF_V h7
346342: , fnd_lookup_values fvl39
346343: , fnd_lookup_values fvl85
346344: , fnd_lookup_values fvl114
346345: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
346346: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
346347: AND xet.event_type_code = C_EVENT_TYPE_CODE
346348: AND h1.event_id = xet.event_id
346349: 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 h7.pla_cat_organization_id (+) = h1.organization_id

Line 346515: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

346511: ELSE null
346512: END source_meaning
346513: FROM xla_events_gt xet
346514: , CST_XLA_INV_LINES_V l2
346515: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
346516: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
346517: AND xet.event_type_code = C_EVENT_TYPE_CODE
346518: AND l2.event_id = xet.event_id
346519:

Line 347823: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

347819: , CST_XLA_PLA_CATEGORY_REF_V h7
347820: , fnd_lookup_values fvl39
347821: , fnd_lookup_values fvl85
347822: , fnd_lookup_values fvl114
347823: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
347824: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
347825: AND xet.event_type_code = C_EVENT_TYPE_CODE
347826: AND h1.event_id = xet.event_id
347827: 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 h7.pla_cat_organization_id (+) = h1.organization_id

Line 347993: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

347989: ELSE null
347990: END source_meaning
347991: FROM xla_events_gt xet
347992: , CST_XLA_INV_LINES_V l2
347993: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
347994: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
347995: AND xet.event_type_code = C_EVENT_TYPE_CODE
347996: AND l2.event_id = xet.event_id
347997:

Line 349290: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

349286: , CST_XLA_RCV_REF_V h3
349287: , PO_DISTS_REF_V h4
349288: , fnd_lookup_values fvl85
349289: , fnd_lookup_values fvl114
349290: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
349291: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
349292: AND xet.event_class_code = C_EVENT_CLASS_CODE
349293: AND h1.event_id = xet.event_id
349294: 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 fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 349416: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

349412: END source_value
349413: , null source_meaning
349414: FROM xla_events_gt xet
349415: , CST_XLA_RCV_LINES_V l2
349416: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
349417: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
349418: AND xet.event_class_code = C_EVENT_CLASS_CODE
349419: AND l2.event_id = xet.event_id
349420:

Line 350554: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

350550: , CST_XLA_RCV_REF_V h3
350551: , PO_DISTS_REF_V h4
350552: , fnd_lookup_values fvl85
350553: , fnd_lookup_values fvl114
350554: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
350555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
350556: AND xet.event_class_code = C_EVENT_CLASS_CODE
350557: AND h1.event_id = xet.event_id
350558: 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 fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 350680: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

350676: END source_value
350677: , null source_meaning
350678: FROM xla_events_gt xet
350679: , CST_XLA_RCV_LINES_V l2
350680: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
350681: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
350682: AND xet.event_class_code = C_EVENT_CLASS_CODE
350683: AND l2.event_id = xet.event_id
350684:

Line 351823: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

351819: , CST_XLA_PLA_CATEGORY_REF_V h6
351820: , fnd_lookup_values fvl62
351821: , fnd_lookup_values fvl85
351822: , fnd_lookup_values fvl114
351823: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
351824: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
351825: AND xet.event_type_code = C_EVENT_TYPE_CODE
351826: AND h1.event_id = xet.event_id
351827: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 351993: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

351989: ELSE null
351990: END source_meaning
351991: FROM xla_events_gt xet
351992: , CST_XLA_INV_LINES_V l2
351993: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
351994: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
351995: AND xet.event_type_code = C_EVENT_TYPE_CODE
351996: AND l2.event_id = xet.event_id
351997:

Line 353412: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

353408: , CST_XLA_PLA_CATEGORY_REF_V h6
353409: , fnd_lookup_values fvl62
353410: , fnd_lookup_values fvl85
353411: , fnd_lookup_values fvl114
353412: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
353413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
353414: AND xet.event_type_code = C_EVENT_TYPE_CODE
353415: AND h1.event_id = xet.event_id
353416: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 353582: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

353578: ELSE null
353579: END source_meaning
353580: FROM xla_events_gt xet
353581: , CST_XLA_INV_LINES_V l2
353582: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
353583: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
353584: AND xet.event_type_code = C_EVENT_TYPE_CODE
353585: AND l2.event_id = xet.event_id
353586:

Line 354814: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

354810: , CST_XLA_PLA_CATEGORY_REF_V h6
354811: , fnd_lookup_values fvl62
354812: , fnd_lookup_values fvl85
354813: , fnd_lookup_values fvl114
354814: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
354815: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
354816: AND xet.event_type_code = C_EVENT_TYPE_CODE
354817: AND h1.event_id = xet.event_id
354818: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 354984: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

354980: ELSE null
354981: END source_meaning
354982: FROM xla_events_gt xet
354983: , CST_XLA_INV_LINES_V l2
354984: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
354985: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
354986: AND xet.event_type_code = C_EVENT_TYPE_CODE
354987: AND l2.event_id = xet.event_id
354988:

Line 356231: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

356227: , CST_XLA_PLA_CATEGORY_REF_V h6
356228: , fnd_lookup_values fvl62
356229: , fnd_lookup_values fvl85
356230: , fnd_lookup_values fvl114
356231: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
356232: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
356233: AND xet.event_type_code = C_EVENT_TYPE_CODE
356234: AND h1.event_id = xet.event_id
356235: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 356401: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

356397: ELSE null
356398: END source_meaning
356399: FROM xla_events_gt xet
356400: , CST_XLA_INV_LINES_V l2
356401: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
356402: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
356403: AND xet.event_type_code = C_EVENT_TYPE_CODE
356404: AND l2.event_id = xet.event_id
356405:

Line 357876: ,(select rownum r from all_objects where rownum <= 24 and owner = p_apps_owner)

357872: , PO_HEADERS_REF_V h8
357873: , PSA_CST_XLA_UPG_V h9
357874: , fnd_lookup_values fvl85
357875: , fnd_lookup_values fvl114
357876: ,(select rownum r from all_objects where rownum <= 24 and owner = p_apps_owner)
357877: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
357878: AND xet.event_type_code = C_EVENT_TYPE_CODE
357879: AND h1.event_id = xet.event_id
357880: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 358042: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

358038: ELSE null
358039: END source_meaning
358040: FROM xla_events_gt xet
358041: , CST_XLA_INV_LINES_V l2
358042: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
358043: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
358044: AND xet.event_type_code = C_EVENT_TYPE_CODE
358045: AND l2.event_id = xet.event_id
358046:

Line 359751: ,(select rownum r from all_objects where rownum <= 24 and owner = p_apps_owner)

359747: , PO_HEADERS_REF_V h8
359748: , PSA_CST_XLA_UPG_V h9
359749: , fnd_lookup_values fvl85
359750: , fnd_lookup_values fvl114
359751: ,(select rownum r from all_objects where rownum <= 24 and owner = p_apps_owner)
359752: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
359753: AND xet.event_type_code = C_EVENT_TYPE_CODE
359754: AND h1.event_id = xet.event_id
359755: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 359917: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

359913: ELSE null
359914: END source_meaning
359915: FROM xla_events_gt xet
359916: , CST_XLA_INV_LINES_V l2
359917: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
359918: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
359919: AND xet.event_type_code = C_EVENT_TYPE_CODE
359920: AND l2.event_id = xet.event_id
359921:

Line 361631: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

361627: , PO_HEADERS_REF_V h8
361628: , PSA_CST_XLA_UPG_V h9
361629: , fnd_lookup_values fvl85
361630: , fnd_lookup_values fvl114
361631: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
361632: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
361633: AND xet.event_type_code = C_EVENT_TYPE_CODE
361634: AND h1.event_id = xet.event_id
361635: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 361797: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

361793: ELSE null
361794: END source_meaning
361795: FROM xla_events_gt xet
361796: , CST_XLA_INV_LINES_V l2
361797: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
361798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
361799: AND xet.event_type_code = C_EVENT_TYPE_CODE
361800: AND l2.event_id = xet.event_id
361801:

Line 363448: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

363444: , CST_XLA_INV_TXN_TYPES_REF_V h5
363445: , CST_XLA_PLA_CATEGORY_REF_V h6
363446: , fnd_lookup_values fvl85
363447: , fnd_lookup_values fvl114
363448: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
363449: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
363450: AND xet.event_type_code = C_EVENT_TYPE_CODE
363451: AND h1.event_id = xet.event_id
363452: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 363614: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

363610: ELSE null
363611: END source_meaning
363612: FROM xla_events_gt xet
363613: , CST_XLA_INV_LINES_V l2
363614: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
363615: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
363616: AND xet.event_type_code = C_EVENT_TYPE_CODE
363617: AND l2.event_id = xet.event_id
363618:

Line 364891: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

364887: , CST_XLA_INV_TXN_TYPES_REF_V h5
364888: , CST_XLA_PLA_CATEGORY_REF_V h6
364889: , fnd_lookup_values fvl85
364890: , fnd_lookup_values fvl114
364891: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
364892: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
364893: AND xet.event_type_code = C_EVENT_TYPE_CODE
364894: AND h1.event_id = xet.event_id
364895: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 365057: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

365053: ELSE null
365054: END source_meaning
365055: FROM xla_events_gt xet
365056: , CST_XLA_INV_LINES_V l2
365057: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
365058: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
365059: AND xet.event_type_code = C_EVENT_TYPE_CODE
365060: AND l2.event_id = xet.event_id
365061:

Line 366240: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

366236: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
366237: , CST_XLA_INV_TXN_TYPES_REF_V h5
366238: , fnd_lookup_values fvl85
366239: , fnd_lookup_values fvl114
366240: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
366241: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
366242: AND xet.event_class_code = C_EVENT_CLASS_CODE
366243: AND h1.event_id = xet.event_id
366244: 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 fvl85.lookup_type(+) =

Line 366387: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

366383: END source_value
366384: , null source_meaning
366385: FROM xla_events_gt xet
366386: , CST_XLA_INV_LINES_V l2
366387: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
366388: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
366389: AND xet.event_class_code = C_EVENT_CLASS_CODE
366390: AND l2.event_id = xet.event_id
366391:

Line 367544: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

367540: , CST_XLA_INV_TXN_TYPES_REF_V h5
367541: , CST_XLA_PLA_CATEGORY_REF_V h6
367542: , fnd_lookup_values fvl85
367543: , fnd_lookup_values fvl114
367544: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
367545: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
367546: AND xet.event_class_code = C_EVENT_CLASS_CODE
367547: AND h1.event_id = xet.event_id
367548: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 367711: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

367707: ELSE null
367708: END source_meaning
367709: FROM xla_events_gt xet
367710: , CST_XLA_INV_LINES_V l2
367711: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
367712: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
367713: AND xet.event_class_code = C_EVENT_CLASS_CODE
367714: AND l2.event_id = xet.event_id
367715:

Line 368968: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

368964: , fnd_lookup_values fvl7
368965: , fnd_lookup_values fvl55
368966: , fnd_lookup_values fvl85
368967: , fnd_lookup_values fvl114
368968: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
368969: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
368970: AND xet.event_type_code = C_EVENT_TYPE_CODE
368971: AND h6.event_id = xet.event_id
368972: AND h1.dis_job_wip_entity_id (+) = h6.wip_entity_id AND h2.flo_sch_wip_entity_id (+) = h6.wip_entity_id AND h3.inventory_item_id (+) = h6.inventory_item_id and h3.organization_id (+) = h6.organization_id AND h4.rep_itm_wip_entity_id (+) = h6.wip_entity_id and h4.rep_itm_line_id (+) = h6.line_id AND h5.wip_entity_id = h6.wip_entity_id AND fvl7.lookup_type(+) = 'WIP_TRANSACTION_TYPE'

Line 369101: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

369097: END source_value
369098: , null source_meaning
369099: FROM xla_events_gt xet
369100: , CST_XLA_WIP_LINES_V l7
369101: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
369102: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
369103: AND xet.event_type_code = C_EVENT_TYPE_CODE
369104: AND l7.event_id = xet.event_id
369105:

Line 370527: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

370523: , PO_HEADERS_REF_V h5
370524: , PSA_CST_XLA_PEA_UPG_V h6
370525: , fnd_lookup_values fvl85
370526: , fnd_lookup_values fvl114
370527: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
370528: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
370529: AND xet.event_class_code = C_EVENT_CLASS_CODE
370530: AND h1.event_id = xet.event_id
370531: 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 fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 370653: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

370649: END source_value
370650: , null source_meaning
370651: FROM xla_events_gt xet
370652: , CST_XLA_RCV_LINES_V l2
370653: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
370654: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
370655: AND xet.event_class_code = C_EVENT_CLASS_CODE
370656: AND l2.event_id = xet.event_id
370657:

Line 371963: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

371959: , PO_HEADERS_REF_V h10
371960: , PSA_CST_XLA_UPG_V h11
371961: , fnd_lookup_values fvl85
371962: , fnd_lookup_values fvl114
371963: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
371964: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
371965: AND xet.event_type_code = C_EVENT_TYPE_CODE
371966: AND h1.event_id = xet.event_id
371967: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h6.inventory_item_id (+) = h1.inventory_item_id and h6.organization_id (+) = h1.organization_id AND h7.inv_transaction_type_id = h1.transaction_type_id AND h8.pla_cat_organization_id (+) = h1.organization_id

Line 372137: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

372133: FROM xla_events_gt xet
372134: , CST_XLA_INV_LINES_V l2
372135: , CST_XLA_INV_SEC_INVS_REF_V l5
372136: , fnd_lookup_values fvl110
372137: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
372138: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
372139: AND xet.event_type_code = C_EVENT_TYPE_CODE
372140: AND l2.event_id = xet.event_id
372141: AND l5.subinventory (+) = l2.subinventory_code and l5.subinv_organization_id (+) = l2.l_organization_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 373884: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)

373880: , PO_HEADERS_REF_V h10
373881: , PSA_CST_XLA_UPG_V h11
373882: , fnd_lookup_values fvl85
373883: , fnd_lookup_values fvl114
373884: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
373885: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
373886: AND xet.event_type_code = C_EVENT_TYPE_CODE
373887: AND h1.event_id = xet.event_id
373888: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h6.inventory_item_id (+) = h1.inventory_item_id and h6.organization_id (+) = h1.organization_id AND h7.inv_transaction_type_id = h1.transaction_type_id AND h8.pla_cat_organization_id (+) = h1.organization_id

Line 374058: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

374054: FROM xla_events_gt xet
374055: , CST_XLA_INV_LINES_V l2
374056: , CST_XLA_INV_SEC_INVS_REF_V l5
374057: , fnd_lookup_values fvl110
374058: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
374059: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
374060: AND xet.event_type_code = C_EVENT_TYPE_CODE
374061: AND l2.event_id = xet.event_id
374062: AND l5.subinventory (+) = l2.subinventory_code and l5.subinv_organization_id (+) = l2.l_organization_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 375702: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

375698: FROM xla_events_gt xet
375699: , CST_XLA_RCV_HEADERS_V h1
375700: , fnd_lookup_values fvl85
375701: , fnd_lookup_values fvl114
375702: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
375703: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
375704: AND xet.event_class_code = C_EVENT_CLASS_CODE
375705: AND h1.event_id = xet.event_id
375706: AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 375828: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

375824: END source_value
375825: , null source_meaning
375826: FROM xla_events_gt xet
375827: , CST_XLA_RCV_LINES_V l2
375828: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
375829: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
375830: AND xet.event_class_code = C_EVENT_CLASS_CODE
375831: AND l2.event_id = xet.event_id
375832:

Line 377037: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

377033: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
377034: , CST_XLA_INV_TXN_TYPES_REF_V h5
377035: , fnd_lookup_values fvl85
377036: , fnd_lookup_values fvl114
377037: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
377038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
377039: AND xet.event_class_code = C_EVENT_CLASS_CODE
377040: AND h1.event_id = xet.event_id
377041: 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 fvl85.lookup_type(+) =

Line 377184: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

377180: END source_value
377181: , null source_meaning
377182: FROM xla_events_gt xet
377183: , CST_XLA_INV_LINES_V l2
377184: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
377185: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
377186: AND xet.event_class_code = C_EVENT_CLASS_CODE
377187: AND l2.event_id = xet.event_id
377188:

Line 378302: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

378298: FROM xla_events_gt xet
378299: , CST_XLA_RCV_HEADERS_V h1
378300: , fnd_lookup_values fvl85
378301: , fnd_lookup_values fvl114
378302: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
378303: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
378304: AND xet.event_class_code = C_EVENT_CLASS_CODE
378305: AND h1.event_id = xet.event_id
378306: AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 378428: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

378424: END source_value
378425: , null source_meaning
378426: FROM xla_events_gt xet
378427: , CST_XLA_RCV_LINES_V l2
378428: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
378429: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
378430: AND xet.event_class_code = C_EVENT_CLASS_CODE
378431: AND l2.event_id = xet.event_id
378432:

Line 379534: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

379530: FROM xla_events_gt xet
379531: , CST_XLA_RCV_HEADERS_V h1
379532: , fnd_lookup_values fvl85
379533: , fnd_lookup_values fvl114
379534: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
379535: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
379536: AND xet.event_class_code = C_EVENT_CLASS_CODE
379537: AND h1.event_id = xet.event_id
379538: AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 379660: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

379656: END source_value
379657: , null source_meaning
379658: FROM xla_events_gt xet
379659: , CST_XLA_RCV_LINES_V l2
379660: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
379661: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
379662: AND xet.event_class_code = C_EVENT_CLASS_CODE
379663: AND l2.event_id = xet.event_id
379664:

Line 380906: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

380902: , PO_HEADERS_REF_V h10
380903: , PSA_CST_XLA_UPG_V h11
380904: , fnd_lookup_values fvl85
380905: , fnd_lookup_values fvl114
380906: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
380907: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
380908: AND xet.event_type_code = C_EVENT_TYPE_CODE
380909: AND h1.event_id = xet.event_id
380910: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h6.inventory_item_id (+) = h1.inventory_item_id and h6.organization_id (+) = h1.organization_id AND h7.inv_transaction_type_id = h1.transaction_type_id AND h8.pla_cat_organization_id (+) = h1.organization_id

Line 381080: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

381076: FROM xla_events_gt xet
381077: , CST_XLA_INV_LINES_V l2
381078: , CST_XLA_INV_SEC_INVS_REF_V l5
381079: , fnd_lookup_values fvl110
381080: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
381081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
381082: AND xet.event_type_code = C_EVENT_TYPE_CODE
381083: AND l2.event_id = xet.event_id
381084: AND l5.subinventory (+) = l2.subinventory_code and l5.subinv_organization_id (+) = l2.l_organization_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 382753: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

382749: , CST_XLA_INV_TXN_TYPES_REF_V h5
382750: , CST_XLA_PLA_CATEGORY_REF_V h6
382751: , fnd_lookup_values fvl85
382752: , fnd_lookup_values fvl114
382753: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
382754: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
382755: AND xet.event_type_code = C_EVENT_TYPE_CODE
382756: AND h1.event_id = xet.event_id
382757: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 382919: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

382915: ELSE null
382916: END source_meaning
382917: FROM xla_events_gt xet
382918: , CST_XLA_INV_LINES_V l2
382919: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
382920: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
382921: AND xet.event_type_code = C_EVENT_TYPE_CODE
382922: AND l2.event_id = xet.event_id
382923:

Line 384230: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

384226: , CST_XLA_INV_TXN_TYPES_REF_V h5
384227: , CST_XLA_PLA_CATEGORY_REF_V h6
384228: , fnd_lookup_values fvl85
384229: , fnd_lookup_values fvl114
384230: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
384231: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
384232: AND xet.event_type_code = C_EVENT_TYPE_CODE
384233: AND h1.event_id = xet.event_id
384234: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 384396: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

384392: ELSE null
384393: END source_meaning
384394: FROM xla_events_gt xet
384395: , CST_XLA_INV_LINES_V l2
384396: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
384397: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
384398: AND xet.event_type_code = C_EVENT_TYPE_CODE
384399: AND l2.event_id = xet.event_id
384400:

Line 385694: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

385690: , CST_XLA_INV_TXN_TYPES_REF_V h5
385691: , CST_XLA_PLA_CATEGORY_REF_V h6
385692: , fnd_lookup_values fvl85
385693: , fnd_lookup_values fvl114
385694: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
385695: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
385696: AND xet.event_type_code = C_EVENT_TYPE_CODE
385697: AND h1.event_id = xet.event_id
385698: 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 h6.pla_cat_organization_id (+) = h1.organization_id

Line 385860: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

385856: ELSE null
385857: END source_meaning
385858: FROM xla_events_gt xet
385859: , CST_XLA_INV_LINES_V l2
385860: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
385861: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
385862: AND xet.event_type_code = C_EVENT_TYPE_CODE
385863: AND l2.event_id = xet.event_id
385864:

Line 387179: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

387175: , CST_XLA_PLA_CATEGORY_REF_V h7
387176: , fnd_lookup_values fvl39
387177: , fnd_lookup_values fvl85
387178: , fnd_lookup_values fvl114
387179: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
387180: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
387181: AND xet.event_type_code = C_EVENT_TYPE_CODE
387182: AND h1.event_id = xet.event_id
387183: 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 h7.pla_cat_organization_id (+) = h1.organization_id

Line 387349: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

387345: ELSE null
387346: END source_meaning
387347: FROM xla_events_gt xet
387348: , CST_XLA_INV_LINES_V l2
387349: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
387350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
387351: AND xet.event_type_code = C_EVENT_TYPE_CODE
387352: AND l2.event_id = xet.event_id
387353:

Line 388684: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

388680: , CST_XLA_INV_TXN_TYPES_REF_V h5
388681: , CST_XLA_PLA_CATEGORY_REF_V h6
388682: , fnd_lookup_values fvl85
388683: , fnd_lookup_values fvl114
388684: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
388685: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
388686: AND xet.event_type_code = C_EVENT_TYPE_CODE
388687: AND h1.event_id = xet.event_id
388688: 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 h6.pla_cat_organization_id (+) = h1.organization_id and h6.pla_cat_item_id (+) = h1.inventory_item_id and h6.pla_subinv_cg (+) = h1.h_subinv_cg AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 388848: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

388844: ELSE null
388845: END source_meaning
388846: FROM xla_events_gt xet
388847: , CST_XLA_INV_LINES_V l2
388848: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
388849: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
388850: AND xet.event_type_code = C_EVENT_TYPE_CODE
388851: AND l2.event_id = xet.event_id
388852:

Line 390231: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)

390227: , CST_XLA_PLA_CATEGORY_REF_V h6
390228: , CST_XLA_TRF_PLA_CAT_REF_V h7
390229: , fnd_lookup_values fvl85
390230: , fnd_lookup_values fvl114
390231: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
390232: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
390233: AND xet.event_type_code = C_EVENT_TYPE_CODE
390234: AND h1.event_id = xet.event_id
390235: 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 h6.pla_cat_organization_id (+) = h1.organization_id and h6.pla_cat_item_id (+) = h1.inventory_item_id and h6.pla_subinv_cg (+) = h1.h_subinv_cg AND h7.trf_pla_cat_organization_id (+) = h1.transfer_organization_id and h7.trf_pla_cat_item_id (+) = h1.inventory_item_id and h7.trf_pla_subinv_cg (+) = h1.h_trf_subinv_cg AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 390406: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

390402: ELSE null
390403: END source_meaning
390404: FROM xla_events_gt xet
390405: , CST_XLA_INV_LINES_V l2
390406: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
390407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
390408: AND xet.event_type_code = C_EVENT_TYPE_CODE
390409: AND l2.event_id = xet.event_id
390410:

Line 391791: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

391787: , CST_XLA_INV_TXN_TYPES_REF_V h6
391788: , CST_XLA_PLA_CATEGORY_REF_V h7
391789: , fnd_lookup_values fvl85
391790: , fnd_lookup_values fvl114
391791: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
391792: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
391793: AND xet.event_type_code = C_EVENT_TYPE_CODE
391794: AND h2.event_id = xet.event_id
391795: AND h1.event_id (+) = h2.event_id

Line 391956: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

391952: ELSE null
391953: END source_meaning
391954: FROM xla_events_gt xet
391955: , CST_XLA_INV_LINES_V l3
391956: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
391957: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
391958: AND xet.event_type_code = C_EVENT_TYPE_CODE
391959: AND l3.event_id = xet.event_id
391960:

Line 393471: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

393467: , CST_XLA_INV_HEADERS_V h2
393468: , CST_XLA_PLA_CATEGORY_REF_V h4
393469: , fnd_lookup_values fvl85
393470: , fnd_lookup_values fvl114
393471: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
393472: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
393473: AND xet.event_type_code = C_EVENT_TYPE_CODE
393474: AND h2.event_id = xet.event_id
393475: AND h1.event_id (+) = h2.event_id

Line 393636: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

393632: ELSE null
393633: END source_meaning
393634: FROM xla_events_gt xet
393635: , CST_XLA_INV_LINES_V l3
393636: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
393637: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
393638: AND xet.event_type_code = C_EVENT_TYPE_CODE
393639: AND l3.event_id = xet.event_id
393640:

Line 395096: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

395092: , CST_XLA_INV_TXN_TYPES_REF_V h6
395093: , CST_XLA_PLA_CATEGORY_REF_V h7
395094: , fnd_lookup_values fvl85
395095: , fnd_lookup_values fvl114
395096: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
395097: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
395098: AND xet.event_type_code = C_EVENT_TYPE_CODE
395099: AND h2.event_id = xet.event_id
395100: AND h1.event_id (+) = h2.event_id

Line 395261: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

395257: ELSE null
395258: END source_meaning
395259: FROM xla_events_gt xet
395260: , CST_XLA_INV_LINES_V l3
395261: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
395262: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
395263: AND xet.event_type_code = C_EVENT_TYPE_CODE
395264: AND l3.event_id = xet.event_id
395265:

Line 396820: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

396816: , CST_XLA_INV_TXN_TYPES_REF_V h7
396817: , CST_XLA_PLA_CATEGORY_REF_V h8
396818: , fnd_lookup_values fvl85
396819: , fnd_lookup_values fvl114
396820: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
396821: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
396822: AND xet.event_type_code = C_EVENT_TYPE_CODE
396823: AND h2.event_id = xet.event_id
396824: AND h1.event_id (+) = h2.event_id

Line 396985: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

396981: ELSE null
396982: END source_meaning
396983: FROM xla_events_gt xet
396984: , CST_XLA_INV_LINES_V l3
396985: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
396986: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
396987: AND xet.event_type_code = C_EVENT_TYPE_CODE
396988: AND l3.event_id = xet.event_id
396989:

Line 398554: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

398550: , CST_XLA_INV_TXN_TYPES_REF_V h6
398551: , CST_XLA_PLA_CATEGORY_REF_V h7
398552: , fnd_lookup_values fvl85
398553: , fnd_lookup_values fvl114
398554: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
398555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
398556: AND xet.event_type_code = C_EVENT_TYPE_CODE
398557: AND h2.event_id = xet.event_id
398558: AND h1.event_id (+) = h2.event_id

Line 398719: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

398715: ELSE null
398716: END source_meaning
398717: FROM xla_events_gt xet
398718: , CST_XLA_INV_LINES_V l3
398719: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
398720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
398721: AND xet.event_type_code = C_EVENT_TYPE_CODE
398722: AND l3.event_id = xet.event_id
398723:

Line 400254: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

400250: , CST_XLA_INV_TXN_TYPES_REF_V h7
400251: , CST_XLA_PLA_CATEGORY_REF_V h8
400252: , fnd_lookup_values fvl85
400253: , fnd_lookup_values fvl114
400254: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
400255: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
400256: AND xet.event_type_code = C_EVENT_TYPE_CODE
400257: AND h2.event_id = xet.event_id
400258: AND h1.event_id (+) = h2.event_id

Line 400419: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

400415: ELSE null
400416: END source_meaning
400417: FROM xla_events_gt xet
400418: , CST_XLA_INV_LINES_V l3
400419: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
400420: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
400421: AND xet.event_type_code = C_EVENT_TYPE_CODE
400422: AND l3.event_id = xet.event_id
400423:

Line 401976: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

401972: , CST_XLA_PLA_CATEGORY_REF_V h8
401973: , fnd_lookup_values fvl39
401974: , fnd_lookup_values fvl85
401975: , fnd_lookup_values fvl114
401976: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
401977: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
401978: AND xet.event_type_code = C_EVENT_TYPE_CODE
401979: AND h2.event_id = xet.event_id
401980: AND h1.event_id (+) = h2.event_id

Line 402145: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

402141: ELSE null
402142: END source_meaning
402143: FROM xla_events_gt xet
402144: , CST_XLA_INV_LINES_V l3
402145: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
402146: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
402147: AND xet.event_type_code = C_EVENT_TYPE_CODE
402148: AND l3.event_id = xet.event_id
402149:

Line 403510: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

403506: , CST_XLA_PLA_CATEGORY_REF_V h8
403507: , fnd_lookup_values fvl39
403508: , fnd_lookup_values fvl85
403509: , fnd_lookup_values fvl114
403510: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
403511: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
403512: AND xet.event_type_code = C_EVENT_TYPE_CODE
403513: AND h2.event_id = xet.event_id
403514: AND h1.event_id (+) = h2.event_id

Line 403674: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

403670: ELSE null
403671: END source_meaning
403672: FROM xla_events_gt xet
403673: , CST_XLA_INV_LINES_V l3
403674: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
403675: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
403676: AND xet.event_type_code = C_EVENT_TYPE_CODE
403677: AND l3.event_id = xet.event_id
403678:

Line 405253: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

405249: , CST_XLA_PLA_CATEGORY_REF_V h8
405250: , fnd_lookup_values fvl39
405251: , fnd_lookup_values fvl85
405252: , fnd_lookup_values fvl114
405253: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
405254: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
405255: AND xet.event_type_code = C_EVENT_TYPE_CODE
405256: AND h2.event_id = xet.event_id
405257: AND h1.event_id (+) = h2.event_id

Line 405417: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

405413: ELSE null
405414: END source_meaning
405415: FROM xla_events_gt xet
405416: , CST_XLA_INV_LINES_V l3
405417: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
405418: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
405419: AND xet.event_type_code = C_EVENT_TYPE_CODE
405420: AND l3.event_id = xet.event_id
405421:

Line 406986: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

406982: , CST_XLA_INV_TXN_TYPES_REF_V h6
406983: , CST_XLA_PLA_CATEGORY_REF_V h7
406984: , fnd_lookup_values fvl85
406985: , fnd_lookup_values fvl114
406986: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
406987: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
406988: AND xet.event_type_code = C_EVENT_TYPE_CODE
406989: AND h2.event_id = xet.event_id
406990: AND h1.event_id (+) = h2.event_id

Line 407151: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

407147: ELSE null
407148: END source_meaning
407149: FROM xla_events_gt xet
407150: , CST_XLA_INV_LINES_V l3
407151: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
407152: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
407153: AND xet.event_type_code = C_EVENT_TYPE_CODE
407154: AND l3.event_id = xet.event_id
407155:

Line 408587: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

408583: , CST_XLA_INV_TXN_TYPES_REF_V h6
408584: , CST_XLA_PLA_CATEGORY_REF_V h7
408585: , fnd_lookup_values fvl85
408586: , fnd_lookup_values fvl114
408587: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
408588: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
408589: AND xet.event_type_code = C_EVENT_TYPE_CODE
408590: AND h2.event_id = xet.event_id
408591: AND h1.event_id (+) = h2.event_id

Line 408747: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

408743: ELSE null
408744: END source_meaning
408745: FROM xla_events_gt xet
408746: , CST_XLA_INV_LINES_V l3
408747: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
408748: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
408749: AND xet.event_type_code = C_EVENT_TYPE_CODE
408750: AND l3.event_id = xet.event_id
408751:

Line 410098: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)

410094: , CST_XLA_PLA_CATEGORY_REF_V h6
410095: , CST_XLA_TRF_PLA_CAT_REF_V h7
410096: , fnd_lookup_values fvl85
410097: , fnd_lookup_values fvl114
410098: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
410099: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
410100: AND xet.event_type_code = C_EVENT_TYPE_CODE
410101: AND h1.event_id = xet.event_id
410102: 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 h6.pla_cat_organization_id (+) = h1.organization_id and h6.pla_cat_item_id (+) = h1.inventory_item_id and h6.pla_subinv_cg (+) = h1.h_subinv_cg AND h7.trf_pla_cat_organization_id (+) = h1.transfer_organization_id and h7.trf_pla_cat_item_id (+) = h1.inventory_item_id and h7.trf_pla_subinv_cg (+) = h1.h_trf_subinv_cg AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 410273: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

410269: ELSE null
410270: END source_meaning
410271: FROM xla_events_gt xet
410272: , CST_XLA_INV_LINES_V l2
410273: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
410274: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
410275: AND xet.event_type_code = C_EVENT_TYPE_CODE
410276: AND l2.event_id = xet.event_id
410277:

Line 411641: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

411637: , CST_XLA_INV_TXN_TYPES_REF_V h5
411638: , CST_XLA_PLA_CATEGORY_REF_V h6
411639: , fnd_lookup_values fvl85
411640: , fnd_lookup_values fvl114
411641: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
411642: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
411643: AND xet.event_type_code = C_EVENT_TYPE_CODE
411644: AND h1.event_id = xet.event_id
411645: 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 h6.pla_cat_organization_id (+) = h1.organization_id and h6.pla_cat_item_id (+) = h1.inventory_item_id and h6.pla_subinv_cg (+) = h1.h_subinv_cg AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 411805: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

411801: ELSE null
411802: END source_meaning
411803: FROM xla_events_gt xet
411804: , CST_XLA_INV_LINES_V l2
411805: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
411806: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
411807: AND xet.event_type_code = C_EVENT_TYPE_CODE
411808: AND l2.event_id = xet.event_id
411809:

Line 413015: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

413011: , CST_XLA_INV_HEADERS_V h1
413012: , CST_XLA_PLA_CATEGORY_REF_V h3
413013: , fnd_lookup_values fvl85
413014: , fnd_lookup_values fvl114
413015: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
413016: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
413017: AND xet.event_type_code = C_EVENT_TYPE_CODE
413018: AND h1.event_id = xet.event_id
413019: AND h3.pla_cat_organization_id (+) = h1.organization_id and h3.pla_cat_item_id (+) = h1.inventory_item_id and h3.pla_subinv_cg (+) = h1.h_subinv_cg AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 413179: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

413175: ELSE null
413176: END source_meaning
413177: FROM xla_events_gt xet
413178: , CST_XLA_INV_LINES_V l2
413179: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
413180: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
413181: AND xet.event_type_code = C_EVENT_TYPE_CODE
413182: AND l2.event_id = xet.event_id
413183:

Line 414440: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)

414436: , CST_XLA_PLA_CATEGORY_REF_V h6
414437: , CST_XLA_TRF_PLA_CAT_REF_V h7
414438: , fnd_lookup_values fvl85
414439: , fnd_lookup_values fvl114
414440: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
414441: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
414442: AND xet.event_type_code = C_EVENT_TYPE_CODE
414443: AND h1.event_id = xet.event_id
414444: 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 h6.pla_cat_organization_id (+) = h1.organization_id and h6.pla_cat_item_id (+) = h1.inventory_item_id and h6.pla_subinv_cg (+) = h1.h_subinv_cg AND h7.trf_pla_cat_organization_id (+) = h1.transfer_organization_id and h7.trf_pla_cat_item_id (+) = h1.inventory_item_id and h7.trf_pla_subinv_cg (+) = h1.h_trf_subinv_cg AND fvl85.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 414615: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

414611: ELSE null
414612: END source_meaning
414613: FROM xla_events_gt xet
414614: , CST_XLA_INV_LINES_V l2
414615: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
414616: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
414617: AND xet.event_type_code = C_EVENT_TYPE_CODE
414618: AND l2.event_id = xet.event_id
414619:

Line 416002: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

415998: , CST_XLA_WIP_HEADERS_V h1
415999: , fnd_lookup_values fvl7
416000: , fnd_lookup_values fvl85
416001: , fnd_lookup_values fvl114
416002: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
416003: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
416004: AND xet.event_class_code = C_EVENT_CLASS_CODE
416005: AND h1.event_id = xet.event_id
416006: AND fvl7.lookup_type(+) = 'WIP_TRANSACTION_TYPE'

Line 416132: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

416128: END source_value
416129: , null source_meaning
416130: FROM xla_events_gt xet
416131: , CST_XLA_WIP_LINES_V l2
416132: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
416133: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
416134: AND xet.event_class_code = C_EVENT_CLASS_CODE
416135: AND l2.event_id = xet.event_id
416136:

Line 417347: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)

417343: , fnd_lookup_values fvl55
417344: , fnd_lookup_values fvl62
417345: , fnd_lookup_values fvl85
417346: , fnd_lookup_values fvl114
417347: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
417348: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
417349: AND xet.event_type_code = C_EVENT_TYPE_CODE
417350: AND h3.event_id = xet.event_id
417351: AND h1.dis_job_wip_entity_id (+) = h6.transaction_source_id AND h2.flo_sch_wip_entity_id (+) = h6.transaction_source_id AND h5.inv_organization_id (+) = h3.organization_id AND h6.ref_transaction_id = h3.transaction_id AND h8.inventory_item_id = h3.inventory_item_id and h8.organization_id = h3.organization_id AND h9.inv_transaction_type_id = h3.transaction_type_id AND h10.pla_cat_organization_id (+) = h3.organization_id

Line 417535: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

417531: , CST_XLA_INV_LINES_V l4
417532: , CST_XLA_INV_SEC_INVS_REF_V l7
417533: , CST_XLA_RES_OVH_REF_V l12
417534: , fnd_lookup_values fvl110
417535: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
417536: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
417537: AND xet.event_type_code = C_EVENT_TYPE_CODE
417538: AND l4.event_id = xet.event_id
417539: AND l7.subinventory (+) = l4.subinventory_code and l7.subinv_organization_id (+) = l4.l_organization_id AND l12.resource_id (+) = l4.material_overhead_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 419070: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)

419066: , fnd_lookup_values fvl55
419067: , fnd_lookup_values fvl62
419068: , fnd_lookup_values fvl85
419069: , fnd_lookup_values fvl114
419070: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
419071: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
419072: AND xet.event_type_code = C_EVENT_TYPE_CODE
419073: AND h3.event_id = xet.event_id
419074: AND h1.dis_job_wip_entity_id (+) = h6.transaction_source_id AND h2.flo_sch_wip_entity_id (+) = h6.transaction_source_id AND h5.inv_organization_id (+) = h3.organization_id AND h6.ref_transaction_id = h3.transaction_id AND h8.inventory_item_id = h3.inventory_item_id and h8.organization_id = h3.organization_id AND h9.inv_transaction_type_id = h3.transaction_type_id AND h10.pla_cat_organization_id (+) = h3.organization_id

Line 419258: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

419254: , CST_XLA_INV_LINES_V l4
419255: , CST_XLA_INV_SEC_INVS_REF_V l7
419256: , CST_XLA_RES_OVH_REF_V l12
419257: , fnd_lookup_values fvl110
419258: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
419259: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
419260: AND xet.event_type_code = C_EVENT_TYPE_CODE
419261: AND l4.event_id = xet.event_id
419262: AND l7.subinventory (+) = l4.subinventory_code and l7.subinv_organization_id (+) = l4.l_organization_id AND l12.resource_id (+) = l4.material_overhead_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 420792: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)

420788: , fnd_lookup_values fvl55
420789: , fnd_lookup_values fvl62
420790: , fnd_lookup_values fvl85
420791: , fnd_lookup_values fvl114
420792: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
420793: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
420794: AND xet.event_type_code = C_EVENT_TYPE_CODE
420795: AND h3.event_id = xet.event_id
420796: AND h1.dis_job_wip_entity_id (+) = h5.transaction_source_id AND h2.flo_sch_wip_entity_id (+) = h5.transaction_source_id AND h5.ref_transaction_id = h3.transaction_id AND h7.inventory_item_id = h3.inventory_item_id and h7.organization_id = h3.organization_id AND h8.inv_transaction_type_id = h3.transaction_type_id AND h9.pla_cat_organization_id (+) = h3.organization_id

Line 420974: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

420970: FROM xla_events_gt xet
420971: , CST_XLA_INV_LINES_V l4
420972: , CST_XLA_INV_SEC_INVS_REF_V l6
420973: , fnd_lookup_values fvl110
420974: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
420975: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
420976: AND xet.event_type_code = C_EVENT_TYPE_CODE
420977: AND l4.event_id = xet.event_id
420978: AND l6.subinventory (+) = l4.subinventory_code and l6.subinv_organization_id (+) = l4.l_organization_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 422497: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

422493: , fnd_lookup_values fvl55
422494: , fnd_lookup_values fvl62
422495: , fnd_lookup_values fvl85
422496: , fnd_lookup_values fvl114
422497: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
422498: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
422499: AND xet.event_type_code = C_EVENT_TYPE_CODE
422500: AND h3.event_id = xet.event_id
422501: AND h1.dis_job_wip_entity_id (+) = h5.transaction_source_id AND h2.flo_sch_wip_entity_id (+) = h5.transaction_source_id AND h5.ref_transaction_id = h3.transaction_id AND h7.inventory_item_id = h3.inventory_item_id and h7.organization_id = h3.organization_id AND h8.inv_transaction_type_id = h3.transaction_type_id AND h9.pla_cat_organization_id (+) = h3.organization_id

Line 422679: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

422675: FROM xla_events_gt xet
422676: , CST_XLA_INV_LINES_V l4
422677: , CST_XLA_INV_SEC_INVS_REF_V l6
422678: , fnd_lookup_values fvl110
422679: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
422680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
422681: AND xet.event_type_code = C_EVENT_TYPE_CODE
422682: AND l4.event_id = xet.event_id
422683: AND l6.subinventory (+) = l4.subinventory_code and l6.subinv_organization_id (+) = l4.l_organization_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 424137: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

424133: , CST_XLA_WIP_HEADERS_V h1
424134: , fnd_lookup_values fvl7
424135: , fnd_lookup_values fvl85
424136: , fnd_lookup_values fvl114
424137: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
424138: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
424139: AND xet.event_class_code = C_EVENT_CLASS_CODE
424140: AND h1.event_id = xet.event_id
424141: AND fvl7.lookup_type(+) = 'WIP_TRANSACTION_TYPE'

Line 424267: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

424263: END source_value
424264: , null source_meaning
424265: FROM xla_events_gt xet
424266: , CST_XLA_WIP_LINES_V l2
424267: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
424268: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
424269: AND xet.event_class_code = C_EVENT_CLASS_CODE
424270: AND l2.event_id = xet.event_id
424271:

Line 425402: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

425398: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
425399: , CST_XLA_INV_TXN_TYPES_REF_V h5
425400: , fnd_lookup_values fvl85
425401: , fnd_lookup_values fvl114
425402: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
425403: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
425404: AND xet.event_type_code = C_EVENT_TYPE_CODE
425405: AND h1.event_id = xet.event_id
425406: 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 fvl85.lookup_type(+) =

Line 425548: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

425544: END source_value
425545: , null source_meaning
425546: FROM xla_events_gt xet
425547: , CST_XLA_INV_LINES_V l2
425548: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
425549: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
425550: AND xet.event_type_code = C_EVENT_TYPE_CODE
425551: AND l2.event_id = xet.event_id
425552:

Line 426704: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

426700: , CST_XLA_WIP_HEADERS_V h1
426701: , fnd_lookup_values fvl7
426702: , fnd_lookup_values fvl85
426703: , fnd_lookup_values fvl114
426704: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
426705: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
426706: AND xet.event_class_code = C_EVENT_CLASS_CODE
426707: AND h1.event_id = xet.event_id
426708: AND fvl7.lookup_type(+) = 'WIP_TRANSACTION_TYPE'

Line 426834: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

426830: END source_value
426831: , null source_meaning
426832: FROM xla_events_gt xet
426833: , CST_XLA_WIP_LINES_V l2
426834: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
426835: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
426836: AND xet.event_class_code = C_EVENT_CLASS_CODE
426837: AND l2.event_id = xet.event_id
426838:

Line 428119: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)

428115: , fnd_lookup_values fvl55
428116: , fnd_lookup_values fvl62
428117: , fnd_lookup_values fvl85
428118: , fnd_lookup_values fvl114
428119: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
428120: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
428121: AND xet.event_type_code = C_EVENT_TYPE_CODE
428122: AND h3.event_id = xet.event_id
428123: AND h1.dis_job_wip_entity_id (+) = h5.transaction_source_id AND h2.flo_sch_wip_entity_id (+) = h5.transaction_source_id AND h5.ref_transaction_id = h3.transaction_id AND h7.inventory_item_id = h3.inventory_item_id and h7.organization_id = h3.organization_id AND h8.inv_transaction_type_id = h3.transaction_type_id AND h9.pla_cat_organization_id (+) = h3.organization_id

Line 428301: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

428297: FROM xla_events_gt xet
428298: , CST_XLA_INV_LINES_V l4
428299: , CST_XLA_INV_SEC_INVS_REF_V l6
428300: , fnd_lookup_values fvl110
428301: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
428302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
428303: AND xet.event_type_code = C_EVENT_TYPE_CODE
428304: AND l4.event_id = xet.event_id
428305: AND l6.subinventory (+) = l4.subinventory_code and l6.subinv_organization_id (+) = l4.l_organization_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 429988: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)

429984: , fnd_lookup_values fvl55
429985: , fnd_lookup_values fvl62
429986: , fnd_lookup_values fvl85
429987: , fnd_lookup_values fvl114
429988: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
429989: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
429990: AND xet.event_type_code = C_EVENT_TYPE_CODE
429991: AND h3.event_id = xet.event_id
429992: AND h1.dis_job_wip_entity_id (+) = h5.transaction_source_id AND h2.flo_sch_wip_entity_id (+) = h5.transaction_source_id AND h5.ref_transaction_id = h3.transaction_id AND h7.inventory_item_id = h3.inventory_item_id and h7.organization_id = h3.organization_id AND h8.inv_transaction_type_id = h3.transaction_type_id AND h9.pla_cat_organization_id (+) = h3.organization_id

Line 430170: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

430166: FROM xla_events_gt xet
430167: , CST_XLA_INV_LINES_V l4
430168: , CST_XLA_INV_SEC_INVS_REF_V l6
430169: , fnd_lookup_values fvl110
430170: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
430171: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
430172: AND xet.event_type_code = C_EVENT_TYPE_CODE
430173: AND l4.event_id = xet.event_id
430174: AND l6.subinventory (+) = l4.subinventory_code and l6.subinv_organization_id (+) = l4.l_organization_id AND fvl110.lookup_type(+) = 'YES_NO'

Line 431707: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

431703: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
431704: , CST_XLA_INV_TXN_TYPES_REF_V h5
431705: , fnd_lookup_values fvl85
431706: , fnd_lookup_values fvl114
431707: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
431708: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
431709: AND xet.event_type_code = C_EVENT_TYPE_CODE
431710: AND h1.event_id = xet.event_id
431711: 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 fvl85.lookup_type(+) =

Line 431853: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

431849: END source_value
431850: , null source_meaning
431851: FROM xla_events_gt xet
431852: , CST_XLA_INV_LINES_V l2
431853: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
431854: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
431855: AND xet.event_type_code = C_EVENT_TYPE_CODE
431856: AND l2.event_id = xet.event_id
431857: