DBA Data[Home] [Help]

APPS.CSI_INV_INTERORG_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 115: FROM mtl_system_items_b

111: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893
112: revision_qty_control_code,
113: location_control_code,
114: comms_nl_trackable_flag
115: FROM mtl_system_items_b
116: WHERE inventory_item_id = pc_item_id
117: AND organization_id = pc_org_id;
118:
119: r_item_control c_item_control%rowtype;

Line 1311: FROM mtl_system_items_b

1307: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893
1308: revision_qty_control_code,
1309: location_control_code,
1310: comms_nl_trackable_flag
1311: FROM mtl_system_items_b
1312: WHERE inventory_item_id = pc_item_id
1313: AND organization_id = pc_org_id;
1314:
1315: r_item_control c_item_control%rowtype;

Line 3147: FROM mtl_system_items_b

3143: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893
3144: revision_qty_control_code,
3145: location_control_code,
3146: comms_nl_trackable_flag
3147: FROM mtl_system_items_b
3148: WHERE inventory_item_id = pc_item_id
3149: AND organization_id = pc_org_id;
3150:
3151: r_item_control c_item_control%rowtype;