APPS.CST_EAMCOST_PUB dependencies on PO_REQUISITION_LINES_ALL

Line 2848: FROM po_requisition_lines_all prla,

2844: prla.category_id category_id,
2845: prha.last_update_date category_date,
2846: null, /* Bug 5201970 */
2847: null /* Bug 5201970 */
2848: FROM po_requisition_lines_all prla,
2849: po_requisition_headers_all prha,
2850: cst_eam_direct_items_temp wediv
2851: WHERE wediv.work_order_number = p_wip_entity_id
2852: AND wediv.organization_id = l_organization_id

Line 4951: FROM po_requisition_lines_all prla,

4947: TO_NUMBER(NULL) line_location_id,
4948: prla.item_description item_description,
4949: prla.item_id item_id,
4950: cedi.req_authorization_status req_auth_status
4951: FROM po_requisition_lines_all prla,
4952: po_requisition_headers_all prha,
4953: cst_eam_direct_items_temp cedi
4954: WHERE cedi.work_order_number = p_wip_entity_id
4955: AND cedi.organization_id = l_organization_id

Line 10028: po_requisition_lines_all rql,

10024: rqh.requisition_header_id,
10025: rql.requisition_line_id,
10026: rql.closed_code
10027: FROM po_requisition_headers_all rqh,
10028: po_requisition_lines_all rql,
10029: po_req_distributions_all rqd
10030: WHERE rql.requisition_header_id = rqh.requisition_header_id AND
10031: rqd.requisition_line_id = rql.requisition_line_id AND
10032: rqd.distribution_id(+) = cedi.req_distribution_id

Line 10090: po_requisition_lines_all rql,

10086: rql.rate, -- CURRENCY_RATE ,
10087: rqh.type_lookup_code, -- DOCUMENT_TYPE
10088: to_char(null) -- IS_SHARED_PROC
10089: FROM
10090: po_requisition_lines_all rql,
10091: po_requisition_headers_all rqh,
10092: po_line_types plt,
10093: mtl_units_of_measure uom,
10094: wip_eam_direct_items wed,