APPS.CSI_MASS_EDIT_PVT dependencies on CSI_ITEM_INSTANCES

Line 60: FROM csi_item_instances

56:
57:
58: CURSOR instance_csr (p_ins_id IN NUMBER) IS
59: SELECT *
60: FROM csi_item_instances
61: WHERE instance_id = p_ins_id;
62:
63: l_instance_csr instance_csr%ROWTYPE;
64:

Line 818: FROM csi_item_instances

814: l_internal_party_id NUMBER := NULL;
815:
816: CURSOR instance_csr (p_ins_id IN NUMBER) IS
817: SELECT *
818: FROM csi_item_instances
819: WHERE instance_id = p_ins_id;
820:
821: l_instance_csr instance_csr%ROWTYPE;
822:

Line 1623: FROM csi_item_instances

1619:
1620:
1621: CURSOR inst_active (pc_instance_id IN NUMBER) IS
1622: SELECT 1
1623: FROM csi_item_instances
1624: WHERE instance_id = pc_instance_id
1625: AND (active_end_date is NULL OR
1626: nvl(active_end_date, sysdate+1) > sysdate);
1627:

Line 1828: ,csi_item_instances cii

1824: ,cii.owner_party_account_id owner_party_account_id
1825: ,cil.txn_line_detail_id txn_line_detail_id
1826: ,cii.instance_id instance_id
1827: FROM csi_t_txn_line_details cil
1828: ,csi_item_instances cii
1829: WHERE cil.transaction_line_id = pc_txn_line_id
1830: AND cil.instance_id IS NOT NULL
1831: AND cil.instance_id = cii.instance_id;
1832:

Line 2326: ,csi_item_instances cii

2322: ,cii.instance_usage_code instance_usage_code
2323: ,cii.instance_id instance_id
2324: ,cii.install_date install_date
2325: FROM csi_t_txn_line_details cil
2326: ,csi_item_instances cii
2327: WHERE cil.transaction_line_id = pc_txn_line_id
2328: AND cil.instance_id IS NOT NULL
2329: AND cil.instance_id = cii.instance_id;
2330: