DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on PO_LINE_LOCATIONS_MERGE_V

Line 4562: FROM PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL

4558: UPDATE PO_SESSION_GT
4559: SET num2 =
4560: (
4561: SELECT POLL.po_line_id
4562: FROM PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL
4563: WHERE POLL.line_location_id = p_doc_level_id_tbl(i)
4564: AND POLL.draft_id = p_draft_id
4565: )
4566: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))

Line 4857: PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL

4853:
4854: SELECT POLL.line_location_id
4855: BULK COLLECT INTO x_line_location_id_tbl
4856: FROM
4857: PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL
4858: , PO_SESSION_GT IDS
4859: WHERE POLL.po_header_id = IDS.num1
4860: and POLL.draft_id = p_draft_id
4861: AND POLL.shipment_type <> g_ship_type_SCHEDULED

Line 4879: PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL

4875:
4876: SELECT POLL.line_location_id
4877: BULK COLLECT INTO x_line_location_id_tbl
4878: FROM
4879: PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL
4880: , PO_SESSION_GT IDS
4881: WHERE POLL.po_line_id = IDS.num1
4882: and POLL.draft_id = p_draft_id
4883: AND POLL.shipment_type <> g_ship_type_SCHEDULED