DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on MTL_ITEM_SUB_DEFAULTS

Line 63: FROM mtl_system_items_b msi, mtl_item_sub_defaults mis,csd_product_transactions cpt

59: msi.inventory_item_id,mis.subinventory_code,cpt.rcv_into_org,cpt.rcv_into_ou,
60: msi.primary_unit_of_measure
61: INTO l_serial_control_flag,l_lot_control_flag,l_primary_uom,
62: l_inventory_item_id,l_subinventory,l_to_org_id,l_destn_ou,l_uom
63: FROM mtl_system_items_b msi, mtl_item_sub_defaults mis,csd_product_transactions cpt
64: WHERE cpt.product_transaction_id = p_product_txn_id
65: AND cpt.rcv_into_org = msi.organization_id
66: AND cpt.inventory_item_id = msi.inventory_item_id
67: AND msi.organization_id = mis.organization_id(+)