APPS.CSD_WIP_JOB_PVT dependencies on MTL_SYSTEM_ITEMS

Line 637: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi

633: crl.unit_of_measure_code,
634: msi.revision_qty_control_code,
635: msi.new_revision_code,
636: SUM(crl.estimate_quantity) AS quantity
637: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi
638: WHERE crl.repair_line_id = p_rep_line_id AND
639: crl.inventory_item_id = msi.inventory_item_id AND
640: msi.organization_id = cs_std.get_item_valdn_orgzn_id AND
641: billing_category = 'M' AND

Line 899: FROM mtl_system_items

895: p_item_id NUMBER
896: )
897: IS
898: SELECT serial_number_control_code
899: FROM mtl_system_items
900: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
901:
902:
903: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is