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_ALL

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 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') --