eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_LINE_LOCATIONS

Line 1241: FROM po_line_locations poll

1237: AND NVL(poh.closed_code, 'OPEN') <> 'OPEN'
1238: )
1239: OR ( poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1240: AND EXISTS (SELECT 'Ship exists not OPEN'
1241: FROM po_line_locations poll
1242: WHERE poll.po_header_id = p_doc_id
1243: AND NVL(poll.consigned_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1244: AND NVL(poll.closed_code, 'OPEN') <> 'OPEN')
1245: )

Line 1253: FROM po_line_locations poll

1249: OR ( polc.lookup_code = 'RECEIVE CLOSE'
1250: AND NVL(poh.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1251: AND poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1252: AND EXISTS (SELECT 'Ships exist OPEN'
1253: FROM po_line_locations poll
1254: WHERE poll.po_header_id = p_doc_id
1255: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING')) --Bug l
1256: )
1257: OR ( polc.lookup_code = 'INVOICE CLOSE'

Line 1261: FROM po_line_locations poll

1257: OR ( polc.lookup_code = 'INVOICE CLOSE'
1258: AND NVL(poh.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1259: AND poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1260: AND EXISTS(SELECT 'Ships exist OPEN'
1261: FROM po_line_locations poll
1262: WHERE poll.po_header_id = p_doc_id
1263: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR INVOICE')) --Bug 954
1264: )
1265: OR ( polc.lookup_code = 'RECEIVE OPEN'

Line 1269: FROM po_line_locations poll

1265: OR ( polc.lookup_code = 'RECEIVE OPEN'
1266: AND NVL(poh.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1267: AND poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1268: AND EXISTS (SELECT 'Ships exist RCLOSED'
1269: FROM po_line_locations poll
1270: WHERE poll.po_header_id = p_doc_id
1271: AND poll.closed_code IN ('CLOSED FOR RECEIVING', 'CLOSED'))
1272: )
1273: OR ( polc.lookup_code = 'INVOICE OPEN'

Line 1276: FROM po_line_locations poll

1272: )
1273: OR ( polc.lookup_code = 'INVOICE OPEN'
1274: AND poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1275: AND EXISTS (SELECT 'Ships exits IC/CLOSED'
1276: FROM po_line_locations poll
1277: WHERE poll.po_header_id = p_doc_id
1278: AND NVL(poll.consigned_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1279: AND poll.closed_code IN ('CLOSED FOR INVOICE', 'CLOSED'))
1280: )

Line 1441: FROM po_line_locations poll

1437: AND NVL(poh.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1438: AND ( (poh.type_lookup_code = 'BLANKET')
1439: OR ( poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1440: AND EXISTS (SELECT 'Ships exist not OPEN'
1441: FROM po_line_locations poll
1442: WHERE poll.po_line_id = p_doc_line_id
1443: AND NVL(poll.consigned_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1444: AND NVL(poll.closed_code, 'OPEN') <> 'OPEN')
1445: )

Line 1452: FROM po_line_locations poll

1448: OR ( polc.lookup_code = 'RECEIVE CLOSE'
1449: AND NVL(poh.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1450: AND poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1451: AND EXISTS (SELECT 'Ships exist that are OPEN'
1452: FROM po_line_locations poll
1453: WHERE poll.po_line_id = p_doc_line_id
1454: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING')) --Bug 5113609
1455: )
1456: OR ( polc.lookup_code = 'INVOICE CLOSE'

Line 1460: FROM po_line_locations poll

1456: OR ( polc.lookup_code = 'INVOICE CLOSE'
1457: AND NVL(poh.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1458: AND poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1459: AND EXISTS (SELECT 'Ships exist OPEN'
1460: FROM po_line_locations poll
1461: WHERE poll.po_line_id = p_doc_line_id
1462: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR INVOICE')) --Bug 5113609
1463: )
1464: OR ( polc.lookup_code = 'RECEIVE OPEN'

Line 1468: FROM po_line_locations poll

1464: OR ( polc.lookup_code = 'RECEIVE OPEN'
1465: AND NVL(poh.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1466: AND poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1467: AND EXISTS (SELECT 'Ships exist RCLOSED'
1468: FROM po_line_locations poll
1469: WHERE poll.po_line_id = p_doc_line_id
1470: AND poll.closed_code IN ('CLOSED FOR RECEIVING', 'CLOSED'))
1471: )
1472: OR ( polc.lookup_code = 'INVOICE OPEN'

Line 1475: FROM po_line_locations poll

1471: )
1472: OR ( polc.lookup_code = 'INVOICE OPEN'
1473: AND poh.type_lookup_code NOT IN ('BLANKET', 'CONTRACT')
1474: AND EXISTS (SELECT 'Ships exits IC/CLOSED'
1475: FROM po_line_locations poll
1476: WHERE poll.po_line_id = p_doc_line_id
1477: AND NVL(poll.consigned_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1478: AND poll.closed_code IN ('CLOSED FOR INVOICE', 'CLOSED'))
1479: )

Line 1595: po_line_locations_all poll,

1591: -- SQL Why: Find all allowable shipment level control actions for this doc
1592: SELECT polc.displayed_field,
1593: polc.lookup_code
1594: FROM po_lookup_codes polc,
1595: po_line_locations_all poll,
1596: po_headers_all poh
1597: WHERE poll.line_location_id = p_doc_line_loc_id
1598: AND poll.po_header_id = poh.po_header_id
1599: AND polc.lookup_type = 'CONTROL ACTIONS'

Line 1877: FROM po_line_locations poll

1873: )
1874: OR ( polc.lookup_code = 'RECEIVE CLOSE'
1875: AND NVL(por.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1876: AND EXISTS (SELECT 'Ships exist that are OPEN'
1877: FROM po_line_locations poll
1878: WHERE poll.po_release_id = p_doc_id
1879: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING')) --Bug 5113609
1880: )
1881: OR ( polc.lookup_code = 'INVOICE CLOSE'

Line 1884: FROM po_line_locations poll

1880: )
1881: OR ( polc.lookup_code = 'INVOICE CLOSE'
1882: AND NVL(por.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1883: AND EXISTS (SELECT 'Ships exist that are OPEN'
1884: FROM po_line_locations poll
1885: WHERE poll.po_release_id = p_doc_id
1886: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR INVOICE')) --Bug 5113609
1887: )
1888: OR ( polc.lookup_code = 'RECEIVE OPEN'

Line 1891: FROM po_line_locations poll

1887: )
1888: OR ( polc.lookup_code = 'RECEIVE OPEN'
1889: AND NVL(por.consigned_consumption_flag, 'N') <> 'Y' /* CONSIGNED FPI */
1890: AND EXISTS (SELECT 'Ships exist that are RCLOSED'
1891: FROM po_line_locations poll
1892: WHERE poll.po_release_id = p_doc_id
1893: AND poll.closed_code IN ('CLOSED FOR RECEIVING', 'CLOSED'))
1894: )
1895: OR ( polc.lookup_code = 'INVOICE OPEN'

Line 1897: FROM po_line_locations poll

1893: AND poll.closed_code IN ('CLOSED FOR RECEIVING', 'CLOSED'))
1894: )
1895: OR ( polc.lookup_code = 'INVOICE OPEN'
1896: AND EXISTS (SELECT 'Ships exits that are IC/CLOSED'
1897: FROM po_line_locations poll
1898: WHERE poll.po_release_id = p_doc_id
1899: AND poll.closed_code IN ('CLOSED FOR INVOICE', 'CLOSED'))
1900: )
1901: )

Line 2011: po_line_locations poll,

2007: -- release.
2008: SELECT polc.displayed_field,
2009: polc.lookup_code
2010: FROM po_lookup_codes polc,
2011: po_line_locations poll,
2012: po_releases por
2013: WHERE poll.line_location_id = p_doc_line_loc_id
2014: AND poll.po_release_id = por.po_release_id
2015: AND polc.lookup_type = 'CONTROL ACTIONS'

Line 3439: -- SQL What: Query PO_LINE_LOCATIONS for shipments

3435: RETURN BOOLEAN
3436: IS
3437:
3438: CURSOR l_has_ship_csr IS
3439: -- SQL What: Query PO_LINE_LOCATIONS for shipments
3440: -- SQL Why: Check if this document has any shipments
3441: --: include PREPAYMENT line locations
3442: SELECT 'Has shipments'
3443: FROM po_line_locations poll

Line 3443: FROM po_line_locations poll

3439: -- SQL What: Query PO_LINE_LOCATIONS for shipments
3440: -- SQL Why: Check if this document has any shipments
3441: --: include PREPAYMENT line locations
3442: SELECT 'Has shipments'
3443: FROM po_line_locations poll
3444: WHERE poll.po_header_id = p_doc_id AND
3445: poll.shipment_type IN
3446: ('STANDARD', 'PLANNED', 'BLANKET', 'PREPAYMENT') AND
3447: NVL(poll.cancel_flag, 'N') = 'N' AND

Line 3450: -- SQL What: Query PO_LINE_LOCATIONS for shipments

3446: ('STANDARD', 'PLANNED', 'BLANKET', 'PREPAYMENT') AND
3447: NVL(poll.cancel_flag, 'N') = 'N' AND
3448: NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED';
3449: CURSOR l_has_rel_ship_csr IS
3450: -- SQL What: Query PO_LINE_LOCATIONS for shipments
3451: -- SQL Why: Check if this release has any shipments
3452: SELECT 'Has shipments'
3453: FROM po_line_locations poll
3454: WHERE poll.po_release_id = p_doc_id AND

Line 3453: FROM po_line_locations poll

3449: CURSOR l_has_rel_ship_csr IS
3450: -- SQL What: Query PO_LINE_LOCATIONS for shipments
3451: -- SQL Why: Check if this release has any shipments
3452: SELECT 'Has shipments'
3453: FROM po_line_locations poll
3454: WHERE poll.po_release_id = p_doc_id AND
3455: poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET') AND
3456: NVL(poll.cancel_flag, 'N') = 'N' AND
3457: NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED';

Line 3862: l_dummy PO_LINE_LOCATIONS_ALL.line_location_id%type := 0;

3858: l_timecard_exists BOOLEAN;
3859: l_otl_field_name VARCHAR2(20);
3860: l_otl_field_value NUMBER;
3861: l_current_entity_changed VARCHAR2(1);
3862: l_dummy PO_LINE_LOCATIONS_ALL.line_location_id%type := 0;
3863: d_pos NUMBER;
3864: l_api_name CONSTANT VARCHAR2(30) := 'Val_Cancel_FinalClose_Action';
3865: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.Val_Cancel_FinalClose_Action' ;
3866: BEGIN

Line 4025: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;

4021: ,x_is_encumbrance_error OUT NOCOPY VARCHAR2
4022: ,x_online_report_id OUT NOCOPY NUMBER--bug#5055417
4023: )
4024: IS
4025: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4026: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4027: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4028: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4029: l_document_version PO_HEADERS_ALL.revision_num%TYPE;

Line 4282: from po_line_locations_all

4278: IF (p_doc_level = PO_CORE_S.g_doc_level_SHIPMENT)
4279: THEN
4280: select shipment_type
4281: into l_doc_subtype
4282: from po_line_locations_all
4283: where line_location_id = p_doc_line_loc_id;
4284: ELSE
4285: l_doc_subtype := p_doc_subtype;
4286: END IF;

Line 4684: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE := NULL;

4680: p_doc_level IN VARCHAR2)
4681: RETURN BOOLEAN
4682: IS
4683: l_po_line_id PO_LINES_ALL.po_line_id%TYPE := NULL;
4684: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE := NULL;
4685: l_has_labor_expense_req BOOLEAN := FALSE;
4686: d_pos NUMBER := 0;
4687: l_api_name CONSTANT VARCHAR2(30) := 'is_backing_req_labor_expense';
4688: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.is_backing_req_labor_expense';

Line 5078: FROM po_line_locations_all poll1,

5074: INTO l_ship_invalid_for_ctrl_actn
5075: FROM DUAL
5076: WHERE EXISTS(
5077: SELECT 1
5078: FROM po_line_locations_all poll1,
5079: po_line_locations_all poll2
5080: WHERE poll1.line_location_id = p_doc_level_id
5081: AND poll1.po_line_id = poll2.po_line_id
5082: AND NVL(poll2.cancel_flag,'N') <> 'Y'

Line 5079: po_line_locations_all poll2

5075: FROM DUAL
5076: WHERE EXISTS(
5077: SELECT 1
5078: FROM po_line_locations_all poll1,
5079: po_line_locations_all poll2
5080: WHERE poll1.line_location_id = p_doc_level_id
5081: AND poll1.po_line_id = poll2.po_line_id
5082: AND NVL(poll2.cancel_flag,'N') <> 'Y'
5083: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --