APPS.CS_CHARGE_DETAILS_PVT dependencies on CSI_ITEM_INSTANCES

Line 1244: FROM csi_item_instances

1240:
1241: Cursor c_instance(p_instance_id IN NUMBER,
1242: p_inv_id IN NUMBER) IS
1243: SELECT instance_id
1244: FROM csi_item_instances
1245: WHERE instance_id = p_instance_id
1246: AND inventory_item_id = p_inv_id;
1247: --AND INV_MASTER_ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id;
1248:

Line 1294: FROM CSI_ITEM_INSTANCES cp,

1290: IS
1291:
1292: CURSOR c_instance IS
1293: SELECT 'Y'
1294: FROM CSI_ITEM_INSTANCES cp,
1295: MTL_SYSTEM_ITEMS_KFV ITEMS
1296: WHERE cp.instance_id = p_instance_id AND
1297: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
1298: -- cp.owner_party_id = p_party_id AND Commented for bug 8552188

Line 1354: FROM csi_item_instances

1350: IS
1351:
1352: Cursor c_instance_serial_number IS
1353: SELECT 'Y'
1354: FROM csi_item_instances
1355: WHERE instance_id = p_instance_id
1356: AND serial_number = p_serial_number;
1357:
1358: lv_exists_flag VARCHAR2(1) := 'N';

Line 3848: FROM csi_item_instances

3844:
3845: -- Added for bug#5125934
3846: Cursor c_serial_number(p_instance_id NUMBER) IS
3847: SELECT serial_number
3848: FROM csi_item_instances
3849: WHERE instance_id = p_instance_id;
3850:
3851: -- 12.1.3 Charges Logistics Project
3852: Cursor c_sub_inventory(p_inv_org_id Number, p_sub_inv_org Varchar2) is