DBA Data[Home] [Help]

APPS.CSI_INV_INTERORG_PKG dependencies on CSI_UTL_PKG

Line 111: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893

107: pc_org_id in number,
108: p_transaction_id in Number) is -- Added for bug#14835893
109: SELECT serial_number_control_code,
110: --lot_control_code,
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

Line 1307: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893

1303: pc_org_id in number,
1304: p_transaction_id in Number) is -- Added for bug#14835893
1305: SELECT serial_number_control_code,
1306: --lot_control_code,
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

Line 3143: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893

3139: pc_org_id in number,
3140: p_transaction_id in Number) is -- Added for bug#14835893
3141: SELECT serial_number_control_code,
3142: -- lot_control_code,
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