APPS.CSD_PROCESS_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 280: from mtl_system_items

276: l_org_id := cs_std.get_item_valdn_orgzn_id;
277:
278: select 'X'
279: into l_dummy
280: from mtl_system_items
281: where inventory_item_id = p_inventory_item_id
282: and organization_id = l_org_id
283: and sysdate between nvl(start_date_active,sysdate)
284: and nvl(end_date_active, sysdate);

Line 656: from mtl_system_items_B

652:
653: begin
654: select MATERIAL_BILLABLE_FLAG
655: into l_billing_type
656: from mtl_system_items_B
657: where inventory_item_id = p_inventory_item_id
658: and organization_id = l_org_id
659: and sysdate between nvl(start_date_active,sysdate)
660: and nvl(end_date_active, sysdate);

Line 864: from mtl_system_items_kfv

860: p_org_id IN NUMBER) IS
861: Select
862: serial_number_control_code,
863: comms_nl_trackable_flag
864: from mtl_system_items_kfv
865: where inventory_item_id = p_inv_item_id
866: and organization_id = p_org_id;
867:
868: --picking_rule_changes for R12

Line 4377: from mtl_system_items

4373: BEGIN
4374:
4375: select serial_number_control_code
4376: into l_serial_code
4377: from mtl_system_items
4378: where inventory_item_id = p_inv_item_id
4379: and organization_id = cs_std.get_item_valdn_orgzn_id;
4380:
4381: IF l_serial_code = 1 then