APPS.ICX_REQ_TEMPLATES dependencies on PO_REQEXPRESS_HEADERS

Line 63: from po_reqexpress_headers

59: v_test := 0;
60:
61: if v_emergency = 'YES' then
62: select count(-1) into v_test
63: from po_reqexpress_headers
64: where express_name = v_return_template
65: and (reserve_po_number = 'YES' OR reserve_po_number = 'OPTIONAL');
66: else
67: select count(-1) into v_test

Line 68: from po_reqexpress_headers

64: where express_name = v_return_template
65: and (reserve_po_number = 'YES' OR reserve_po_number = 'OPTIONAL');
66: else
67: select count(-1) into v_test
68: from po_reqexpress_headers
69: where express_name = v_return_template
70: and (reserve_po_number = 'NO' OR reserve_po_number = 'OPTIONAL' OR reserve_po_number is null);
71: end if;
72:

Line 1323: FROM po_reqexpress_headers prh,

1319: prl.po_header_id,
1320: pl.line_num
1321: -- ,v_requestor_name
1322: -- ,v_requestor_id
1323: FROM po_reqexpress_headers prh,
1324: po_reqexpress_lines prl,
1325: mtl_system_items_kfv msi,
1326: po_vendor_contacts pvc,
1327: po_vendor_sites pvs,

Line 1385: FROM po_reqexpress_headers prh,

1381: prl.po_header_id,
1382: pl.line_num
1383: -- ,v_requestor_name
1384: -- ,v_requestor_id
1385: FROM po_reqexpress_headers prh,
1386: po_reqexpress_lines prl,
1387: po_vendor_contacts pvc,
1388: po_vendor_sites pvs,
1389: po_vendors pv,