APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_LINE_LOCATIONS

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

648: l_type_name po_document_types.type_name%type;
649:
650: /* RETROACTIVE FPI END */
651:
652: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --
653: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE; --
654: --bug##3682458 replaced legal entity name with operating unit
655: l_operating_unit hr_all_organization_units_tl.name%TYPE; --
656:

Line 1284: from po_line_locations

1280: into l_drop_ship_flag
1281: from dual
1282: where exists
1283: (select 'Release DropShip Shipment Exists'
1284: from po_line_locations
1285: where po_release_id = DocumentId
1286: and drop_ship_flag = 'Y');
1287:
1288: ELSIF DocumentTypeCode = 'PO' THEN

Line 1294: from po_line_locations

1290: into l_drop_ship_flag
1291: from dual
1292: where exists
1293: (select 'PO DropShip Shipment Exists'
1294: from po_line_locations
1295: where po_header_id = DocumentId
1296: and drop_ship_flag = 'Y');
1297: END IF;
1298:

Line 4448: from po_line_locations

4444: else
4445: if (p_document_type in ('PO', 'PA')) then
4446: select max(need_by_date)+180
4447: into l_expiration_date
4448: from po_line_locations
4449: where po_header_id = to_number(p_document_id)
4450: and cancel_flag = 'N';
4451:
4452: if l_expiration_date <= sysdate then

Line 4459: from po_line_locations

4455:
4456: elsif (p_document_type = 'RELEASE') then
4457: select max(need_by_date)+180
4458: into l_expiration_date
4459: from po_line_locations
4460: where po_release_id = to_number(p_document_id)
4461: and cancel_flag = 'N';
4462:
4463: if l_expiration_date <= sysdate then