APPS.PO_OM_INTEGRATION_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 163: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;

159:
160: --Bug# 4640038 End
161:
162: -- Bug 3639067
163: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
164:
165: BEGIN
166:
167: IF g_fnd_debug = 'Y' THEN

Line 247: FROM po_line_locations_all

243: -- sales order, requisition, and PO. In this case, we should not
244: -- automatically synchronize SO changes to the req/PO.)
245: SELECT drop_ship_flag
246: INTO l_drop_ship_flag
247: FROM po_line_locations_all
248: WHERE line_location_id = p_po_line_location_id(i);
249:
250: IF (l_drop_ship_flag = 'Y') THEN
251:

Line 397: FROM po_line_locations_all

393: ELSE
394:
395: SELECT round((p_secondary_quantity(i) * l_suom_conversion_rate),5) + NVL(SUM(NVL(secondary_quantity_received,0)),0)
396: INTO l_secondary_quantity_ordered(i)
397: FROM po_line_locations_all
398: WHERE line_location_id = p_po_line_location_id(i);
399: END IF;
400:
401:

Line 811: l_approved_date PO_LINE_LOCATIONS_ALL.approved_date%TYPE;

807: l_doc_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
808:
809: -- Bug 3248723 START
810: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; --
811: l_approved_date PO_LINE_LOCATIONS_ALL.approved_date%TYPE;
812: l_chg PO_CHANGES_REC_TYPE;
813: -- Bug 3248723 END
814: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534
815:

Line 817: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;

813: -- Bug 3248723 END
814: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534
815:
816: -- Bug 3639067 START
817: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
818: l_session_gt_key PO_SESSION_GT.key%TYPE;
819: l_req_header_id PO_TBL_NUMBER;
820: l_req_line_id PO_TBL_NUMBER;
821: -- Bug 3639067 END

Line 872: FROM po_line_locations_all

868: SELECT approved_date,
869: drop_ship_flag -- Bug 3639067
870: INTO l_approved_date,
871: l_drop_ship_flag
872: FROM po_line_locations_all
873: WHERE line_location_id = p_po_line_location_id(i);
874:
875: -- Bug 3639067 START
876: -- Only synchronize if the shipment is flagged as drop ship.

Line 1274: UPDATE po_line_locations_all PLL

1270: --SQL Why: The association between SO and PO will be removed once
1271: -- the SO is purged.
1272:
1273: FORALL i IN 1..p_entity_id_tbl.COUNT
1274: UPDATE po_line_locations_all PLL
1275: SET drop_ship_flag = ''
1276: WHERE PLL.line_location_id = p_entity_id_tbl(i);
1277:
1278: IF (g_fnd_debug = 'Y') THEN

Line 1505: po_line_locations_all PLL

1501: 'N')))
1502: BULK COLLECT INTO x_purge_allowed_tbl
1503: FROM po_session_gt PSG,
1504: po_headers_all PH,
1505: po_line_locations_all PLL
1506: WHERE PSG.key = l_seq_id
1507: AND PSG.num1 = PLL.line_location_id (+)
1508: AND PLL.po_header_id = PH.po_header_id (+)
1509: ORDER BY PSG.num2 asc;