APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 12828: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;

12824:
12825: --14227140 changes starts
12826: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
12827: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
12828: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
12829: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
12830: l_sec_cancelled_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY_CANCELLED%TYPE;
12831: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
12832: --14227140 changes ends

Line 12829: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;

12825: --14227140 changes starts
12826: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
12827: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
12828: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
12829: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
12830: l_sec_cancelled_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY_CANCELLED%TYPE;
12831: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
12832: --14227140 changes ends
12833: BEGIN

Line 12867: FROM mtl_system_items_b

12863: WHERE requisition_line_id = p_req_line_id;
12864:
12865: SELECT PRIMARY_UOM_CODE, SECONDARY_UOM_CODE
12866: INTO l_prim_uom_cde, l_sec_uom_code
12867: FROM mtl_system_items_b
12868: WHERE INVENTORY_ITEM_ID =l_item_id AND ORGANIZATION_ID =l_source_org;
12869: -- populate the secondary qty and update on req line for dual UOM item line.
12870: IF( l_sec_uom_code IS NOT NULL) THEN
12871: x_progress := '014';

Line 13114: mtl_system_items_b mi,

13110: SELECT mp.EMPLOYEE_ID
13111: into l_planner_id
13112: FROM po_change_requests pcr,
13113: po_requisition_lines_all prl,
13114: mtl_system_items_b mi,
13115: financials_system_params_all fsp,
13116: mtl_planners mp
13117: WHERE pcr.change_request_group_id =l_change_request_group_id
13118: AND pcr.change_request_id =L_CHANGE_REQUEST_ID

Line 13140: mtl_system_items_b mi,

13136: l_sql := '
13137: SELECT mp.EMPLOYEE_ID
13138: FROM po_change_requests pcr,
13139: po_requisition_lines_all prl,
13140: mtl_system_items_b mi,
13141: financials_system_params_all fsp,
13142: mtl_planners mp
13143: WHERE pcr.change_request_group_id =:1
13144: AND pcr.change_request_id =:2

Line 13361: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;

13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13360: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
13361: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
13362: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
13363: CURSOR l_changed_req_dists_csr(req_line_id NUMBER) IS
13364: select DISTRIBUTION_ID
13365: from PO_REQ_DISTRIBUTIONS_ALL

Line 13362: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;

13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13360: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
13361: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
13362: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
13363: CURSOR l_changed_req_dists_csr(req_line_id NUMBER) IS
13364: select DISTRIBUTION_ID
13365: from PO_REQ_DISTRIBUTIONS_ALL
13366: where REQUISITION_LINE_ID= req_line_id;

Line 13576: FROM mtl_system_items_b

13572: ELSE
13573: l_progress := '013';
13574: SELECT PRIMARY_UOM_CODE, SECONDARY_UOM_CODE
13575: INTO l_prim_uom_cde, l_sec_uom_code
13576: FROM mtl_system_items_b
13577: WHERE INVENTORY_ITEM_ID =l_item_id AND ORGANIZATION_ID =l_source_org;
13578:
13579: IF( l_sec_uom_code IS NOT NULL) THEN
13580: l_progress := '014';