DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on MTL_SYSTEM_ITEMS_B

Line 664: from mtl_system_items_B

660:
661: begin
662: select MATERIAL_BILLABLE_FLAG
663: into l_billing_type
664: from mtl_system_items_B
665: where inventory_item_id = p_inventory_item_id
666: and organization_id = l_org_id
667: and sysdate between nvl(start_date_active,sysdate)
668: and nvl(end_date_active, sysdate);

Line 6246: from MTL_SYSTEM_ITEMS_B

6242:
6243: --bug#13498183
6244: SELECT SERIAL_NUMBER_CONTROL_CODE
6245: INTO l_SERIAL_CONTROL_CODE
6246: from MTL_SYSTEM_ITEMS_B
6247: WHERE INVENTORY_ITEM_ID = p_inventory_item_id AND ORGANIZATION_ID = p_org_id;
6248: --bug#13498183
6249:
6250: -- if negative inventory is not allowed and the subinv is specified in the