APPS.PO_OM_INTEGRATION_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 158: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;

154:
155: --Bug# 4640038 End
156:
157: -- Bug 3639067
158: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
159:
160: BEGIN
161:
162: IF g_fnd_debug = 'Y' THEN

Line 242: FROM po_line_locations_all

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

Line 392: FROM po_line_locations_all

388: ELSE
389:
390: SELECT round((p_secondary_quantity(i) * l_suom_conversion_rate),5) + NVL(SUM(NVL(secondary_quantity_received,0)),0)
391: INTO l_secondary_quantity_ordered(i)
392: FROM po_line_locations_all
393: WHERE line_location_id = p_po_line_location_id(i);
394: END IF;
395:
396:

Line 685: l_approved_date PO_LINE_LOCATIONS_ALL.approved_date%TYPE;

681: l_doc_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
682:
683: -- Bug 3248723 START
684: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; --
685: l_approved_date PO_LINE_LOCATIONS_ALL.approved_date%TYPE;
686: l_chg PO_CHANGES_REC_TYPE;
687: -- Bug 3248723 END
688: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534
689:

Line 691: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;

687: -- Bug 3248723 END
688: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534
689:
690: -- Bug 3639067 START
691: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
692: l_session_gt_key PO_SESSION_GT.key%TYPE;
693: l_req_header_id PO_TBL_NUMBER;
694: l_req_line_id PO_TBL_NUMBER;
695: -- Bug 3639067 END

Line 746: FROM po_line_locations_all

742: SELECT approved_date,
743: drop_ship_flag -- Bug 3639067
744: INTO l_approved_date,
745: l_drop_ship_flag
746: FROM po_line_locations_all
747: WHERE line_location_id = p_po_line_location_id(i);
748:
749: -- Bug 3639067 START
750: -- Only synchronize if the shipment is flagged as drop ship.

Line 1148: UPDATE po_line_locations_all PLL

1144: --SQL Why: The association between SO and PO will be removed once
1145: -- the SO is purged.
1146:
1147: FORALL i IN 1..p_entity_id_tbl.COUNT
1148: UPDATE po_line_locations_all PLL
1149: SET drop_ship_flag = ''
1150: WHERE PLL.line_location_id = p_entity_id_tbl(i);
1151:
1152: IF (g_fnd_debug = 'Y') THEN

Line 1379: po_line_locations_all PLL

1375: 'N')))
1376: BULK COLLECT INTO x_purge_allowed_tbl
1377: FROM po_session_gt PSG,
1378: po_headers_all PH,
1379: po_line_locations_all PLL
1380: WHERE PSG.key = l_seq_id
1381: AND PSG.num1 = PLL.line_location_id (+)
1382: AND PLL.po_header_id = PH.po_header_id (+)
1383: ORDER BY PSG.num2 asc;