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_HEADERS_ALL

Line 223: FROM po_headers_all

219: l_progress :='001';
220:
221: SELECT authorization_status
222: INTO l_auth_status
223: FROM po_headers_all
224: WHERE po_header_id=p_doc_id;
225:
226: ELSE
227:

Line 517: FROM po_headers_all

513: l_progress :='001';
514:
515: SELECT authorization_status
516: INTO l_old_auth_status
517: FROM po_headers_all
518: WHERE po_header_id=p_doc_id;
519:
520: ELSE
521:

Line 1596: po_headers_all poh

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'
1600: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 4026: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

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;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

Line 4027: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;

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;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4031: l_print_flag VARCHAR2(1);

Line 4028: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;

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;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4031: l_print_flag VARCHAR2(1);
4032: l_event_code VARCHAR2(30);

Line 4029: l_document_version PO_HEADERS_ALL.revision_num%TYPE;

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;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4031: l_print_flag VARCHAR2(1);
4032: l_event_code VARCHAR2(30);
4033: SUBTYPE busdocdates_tbl_type IS

Line 4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%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;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4031: l_print_flag VARCHAR2(1);
4032: l_event_code VARCHAR2(30);
4033: SUBTYPE busdocdates_tbl_type IS
4034: okc_manage_deliverables_grp.busdocdates_tbl_type;

Line 4143: from po_headers_all

4139: select conterms_exist_flag, start_date,
4140: end_date, decode(cancel_flag,'I',null,cancel_flag)
4141: into l_conterms_exist_flag, l_document_start_date,
4142: l_document_end_date, l_cancel_flag
4143: from po_headers_all
4144: where po_header_id = p_doc_header_id;
4145: d_pos := 70;
4146:
4147: IF (PO_LOG.d_stmt) THEN

Line 4959: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;

4955: ,x_valid_ctrl_ctn_tbl OUT NOCOPY PO_TBL_VARCHAR30)
4956: IS
4957: l_valid_actions_tbl g_lookup_code_tbl_type;
4958: l_displayed_field_tbl g_displayed_field_tbl_type;
4959: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;
4960: l_cons_trans_exist VARCHAR2(1);
4961: l_index NUMBER;
4962: l_agent_id NUMBER;
4963: l_item_id PO_LINES_ALL.item_Id%TYPE;

Line 4993: FROM po_headers_all

4989: --Get Document Sub type
4990: IF(p_doc_type IN (PO_CORE_S.g_doc_type_PO, PO_CORE_S.g_doc_type_PA)) THEN
4991: SELECT type_lookup_code
4992: INTO l_doc_subtype
4993: FROM po_headers_all
4994: WHERE po_header_id = p_doc_header_id;
4995: END IF;
4996: d_pos := 20;
4997: IF (PO_LOG.d_stmt) THEN

Line 5226: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

5222: d_module CONSTANT VARCHAR2(100) := g_pkg_name|| d_api_name;
5223: l_progress VARCHAR2(3) := '000' ;
5224:
5225:
5226: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
5227: l_auth_status VARCHAR2(30);
5228: l_revision_num NUMBER;
5229: l_request_id NUMBER := 0;
5230: l_doc_type VARCHAR2(30);

Line 5265: FROM po_headers_all

5261: revision_num
5262: INTO l_conterms_exist_flag,
5263: l_auth_status,
5264: l_revision_num
5265: FROM po_headers_all
5266: WHERE po_header_id = p_doc_id;
5267:
5268: ELSE
5269: