DBA Data[Home] [Help]

APPS.ISC_DBI_BOOK_SUM2_REF_PKG dependencies on DUAL

Line 107: FROM dual

103: SOLD_TO_ORG_ID,
104: SHIP_TO_ORG_ID,
105: LINE_ID)
106: SELECT NULL, NULL, NULL, NULL, -1, -1, 0, 0, NULL, NULL, 0, trunc(sysdate), NULL, NULL, NULL
107: FROM dual
108: UNION ALL
109: SELECT inv_org_id,
110: inventory_item_id,
111: customer_id,

Line 235: FROM dual

231: TOP_MODEL_LINE_ID,
232: LINE_ID,
233: ITEM_TYPE_CODE)
234: SELECT NULL, NULL, NULL, NULL, -1, -1, 0, 0, NULL, NULL, 0, 0, 0, 0, -1, -1, trunc(sysdate),0, NULL, NULL, NULL, NULL, NULL
235: FROM dual
236: UNION ALL
237: SELECT inv_org_id,
238: inventory_item_id,
239: customer_id,

Line 365: FROM dual

361: SOLD_TO_ORG_ID,
362: SHIP_TO_ORG_ID,
363: LINE_ID)
364: SELECT NULL, NULL, NULL, -1, -1, NULL, NULL, NULL, 0, 0, 0, NULL, 0, trunc(sysdate), NULL, NULL, NULL
365: FROM dual
366: UNION ALL
367: SELECT fact.item_inv_org_id INV_ORG_ID,
368: fact.inventory_item_id,
369: fact.ship_to_party_id,