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.CSP_PARTS_ORDER dependencies on PO_REQUISITION_HEADERS

Line 1050: SELECT rowid FROM PO_REQUISITION_HEADERS

1046: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1047: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1048:
1049: CURSOR rowid_cur IS
1050: SELECT rowid FROM PO_REQUISITION_HEADERS
1051: WHERE requisition_header_id = l_header_rec.requisition_header_id;
1052:
1053: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
1054: CURSOR req_number_cur IS

Line 1057: WHERE table_name = 'PO_REQUISITION_HEADERS'

1053: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
1054: CURSOR req_number_cur IS
1055: SELECT to_char(current_max_unique_identifier + 1)
1056: FROM po_unique_identifier_control
1057: WHERE table_name = 'PO_REQUISITION_HEADERS'
1058: FOR UPDATE OF current_max_unique_identifier;
1059:
1060: -- Get unique requisition_header_id
1061: CURSOR req_header_id_cur IS

Line 1062: SELECT po_requisition_headers_s.nextval

1058: FOR UPDATE OF current_max_unique_identifier;
1059:
1060: -- Get unique requisition_header_id
1061: CURSOR req_header_id_cur IS
1062: SELECT po_requisition_headers_s.nextval
1063: FROM sys.dual;
1064:
1065: -- Get unique requisition_line_id
1066: CURSOR req_line_id_cur IS

Line 1485: FROM po_requisition_headers

1481: SELECT 1 INTO l_dummy
1482: FROM DUAL
1483: WHERE NOT EXISTS
1484: ( SELECT 1
1485: FROM po_requisition_headers
1486: WHERE Segment1 = l_header_rec.requisition_number)
1487: AND NOT EXISTS
1488: ( SELECT 1
1489: FROM po_history_requisitions phr

Line 1504: 'Inserting data into PO_REQUISITION_HEADERS');

1500:
1501: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1503: 'csp.plsql.csp_parts_order.process_order',
1504: 'Inserting data into PO_REQUISITION_HEADERS');
1505: end if;
1506:
1507: -- create approved requisition headers
1508: -- insert into PO_REQUISITION_HEADERS

Line 1508: -- insert into PO_REQUISITION_HEADERS

1504: 'Inserting data into PO_REQUISITION_HEADERS');
1505: end if;
1506:
1507: -- create approved requisition headers
1508: -- insert into PO_REQUISITION_HEADERS
1509: INSERT INTO PO_REQUISITION_HEADERS(
1510: org_id,
1511: requisition_header_id,
1512: preparer_id,

Line 1509: INSERT INTO PO_REQUISITION_HEADERS(

1505: end if;
1506:
1507: -- create approved requisition headers
1508: -- insert into PO_REQUISITION_HEADERS
1509: INSERT INTO PO_REQUISITION_HEADERS(
1510: org_id,
1511: requisition_header_id,
1512: preparer_id,
1513: last_update_date,

Line 2884: WHERE table_name = 'PO_REQUISITION_HEADERS'

2880: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
2881: CURSOR req_number_cur IS
2882: SELECT to_char(current_max_unique_identifier + 1)
2883: FROM po_unique_identifier_control
2884: WHERE table_name = 'PO_REQUISITION_HEADERS'
2885: FOR UPDATE OF current_max_unique_identifier;
2886:
2887: -- Get unique requisition_header_id
2888: CURSOR req_header_id_cur IS

Line 2889: SELECT po_requisition_headers_s.nextval

2885: FOR UPDATE OF current_max_unique_identifier;
2886:
2887: -- Get unique requisition_header_id
2888: CURSOR req_header_id_cur IS
2889: SELECT po_requisition_headers_s.nextval
2890: FROM sys.dual;
2891:
2892: -- Get unique requisition_line_id
2893: CURSOR req_line_id_cur IS

Line 2975: FROM po_requisition_headers

2971: SELECT 1 INTO l_dummy
2972: FROM DUAL
2973: WHERE NOT EXISTS
2974: ( SELECT 1
2975: FROM po_requisition_headers
2976: WHERE Segment1 = l_header_rec.requisition_number)
2977: AND NOT EXISTS
2978: ( SELECT 1
2979: FROM po_history_requisitions phr