APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_LINE_LOCATIONS

Line 721: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --

717: l_workflow_process_st po_document_types.wf_approval_process%type;
718: l_itemkey VARCHAR2(60);
719: l_type_name po_document_types.type_name%type;
720: /* RETROACTIVE FPI END */
721: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --
722: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE; --
723: --bug##3682458 replaced legal entity name with operating unit
724: l_operating_unit hr_all_organization_units_tl.name%TYPE; --
725: l_document_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 3284628

Line 1363: FROM po_line_locations

1359: INTO l_drop_ship_flag
1360: FROM dual
1361: WHERE EXISTS
1362: (SELECT 'Release DropShip Shipment Exists'
1363: FROM po_line_locations
1364: WHERE po_release_id = DocumentId
1365: AND drop_ship_flag = 'Y'
1366: );
1367: ELSIF DocumentTypeCode = 'PO' THEN

Line 1373: FROM po_line_locations

1369: INTO l_drop_ship_flag
1370: FROM dual
1371: WHERE EXISTS
1372: (SELECT 'PO DropShip Shipment Exists'
1373: FROM po_line_locations
1374: WHERE po_header_id = DocumentId
1375: AND drop_ship_flag = 'Y'
1376: );
1377: END IF;

Line 3779: FROM po_line_locations

3775: ELSE
3776: IF (p_document_type IN ('PO', 'PA')) THEN
3777: SELECT MAX(need_by_date)+180
3778: INTO l_expiration_date
3779: FROM po_line_locations
3780: WHERE po_header_id = to_number(p_document_id)
3781: AND cancel_flag = 'N';
3782: IF l_expiration_date <= sysdate THEN
3783: l_expiration_date := sysdate + 180;

Line 3788: FROM po_line_locations

3784: END IF;
3785: elsif (p_document_type = 'RELEASE') THEN
3786: SELECT MAX(need_by_date)+180
3787: INTO l_expiration_date
3788: FROM po_line_locations
3789: WHERE po_release_id = to_number(p_document_id)
3790: AND cancel_flag = 'N';
3791: IF l_expiration_date <= sysdate THEN
3792: l_expiration_date := sysdate + 180;