APPS.CST_EAMCOST_PUB dependencies on PO_REQUISITION_LINES_ALL

Line 3070: FROM po_requisition_lines_all prla,

3066: prla.category_id category_id,
3067: prha.last_update_date category_date,
3068: null, /* Bug 5201970 */
3069: null /* Bug 5201970 */
3070: FROM po_requisition_lines_all prla,
3071: po_requisition_headers_all prha,
3072: cst_eam_direct_items_temp wediv
3073: WHERE wediv.work_order_number = p_wip_entity_id
3074: AND wediv.organization_id = l_organization_id

Line 5173: FROM po_requisition_lines_all prla,

5169: TO_NUMBER(NULL) line_location_id,
5170: prla.item_description item_description,
5171: prla.item_id item_id,
5172: cedi.req_authorization_status req_auth_status
5173: FROM po_requisition_lines_all prla,
5174: po_requisition_headers_all prha,
5175: cst_eam_direct_items_temp cedi
5176: WHERE cedi.work_order_number = p_wip_entity_id
5177: AND cedi.organization_id = l_organization_id

Line 10741: po_requisition_lines_all rql,

10737: rqh.requisition_header_id,
10738: rql.requisition_line_id,
10739: rql.closed_code
10740: FROM po_requisition_headers_all rqh,
10741: po_requisition_lines_all rql,
10742: po_req_distributions_all rqd
10743: WHERE rql.requisition_header_id = rqh.requisition_header_id AND
10744: rqd.requisition_line_id = rql.requisition_line_id AND
10745: rqd.distribution_id(+) = cedi.req_distribution_id

Line 10803: po_requisition_lines_all rql,

10799: rql.rate, -- CURRENCY_RATE ,
10800: rqh.type_lookup_code, -- DOCUMENT_TYPE
10801: to_char(null) -- IS_SHARED_PROC
10802: FROM
10803: po_requisition_lines_all rql,
10804: po_requisition_headers_all rqh,
10805: po_line_types plt,
10806: mtl_units_of_measure uom,
10807: wip_eam_direct_items wed,