APPS.CSI_MASS_EDIT_PVT dependencies on CSI_T_TXN_LINE_DETAILS

Line 560: From csi_t_txn_line_details

556: x_mass_edit_rec.schedule_date := l_mass_edit_rec.schedule_date;
557:
558: Select txn_line_detail_id
559: Into x_mass_edit_rec.txn_line_detail_id
560: From csi_t_txn_line_details
561: Where transaction_line_id = l_mass_edit_rec.txn_line_id
562: And instance_id is null; -- there can be ONLY one record with no instance ID(dummy...)
563:
564: Return TRUE;

Line 1681: FROM csi_t_txn_line_details cil

1677: ,cid.party_source_table party_source_table
1678: ,cil.txn_line_detail_id txn_line_detail_id
1679: ,cil.instance_id instance_id
1680: ,cid.txn_party_detail_id txn_party_detail_id
1681: FROM csi_t_txn_line_details cil
1682: ,csi_t_party_details cid
1683: WHERE cil.transaction_line_id = pc_txn_line_id
1684: AND cil.instance_id IS NOT NULL
1685: AND cid.txn_line_detail_id = cil.txn_line_detail_id

Line 1691: FROM csi_t_txn_line_details cil

1687:
1688: CURSOR account_csr (pc_txn_line_id IN NUMBER,
1689: pc_txn_party_detail_id IN NUMBER) IS
1690: SELECT cia.account_id
1691: FROM csi_t_txn_line_details cil
1692: ,csi_t_party_details cid
1693: ,csi_t_party_accounts cia
1694: WHERE cil.transaction_line_id = pc_txn_line_id
1695: AND cil.instance_id IS NOT NULL

Line 1827: FROM csi_t_txn_line_details cil

1823: ,cii.owner_party_id owner_party_id
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;

Line 1992: FROM csi_t_txn_line_details cil

1988: SELECT cil.location_id location_id
1989: ,cil.instance_status_id instance_status_id
1990: ,cil.install_location_id install_location_id
1991: ,cil.txn_line_detail_id txn_line_detail_id
1992: FROM csi_t_txn_line_details cil
1993: WHERE cil.transaction_line_id = pc_txn_line_id
1994: AND cil.instance_id IS NULL;
1995:
1996: dummy_rec dummy_csr%rowtype;

Line 2081: FROM csi_t_txn_line_details cil

2077:
2078: CURSOR dummy_csr(pc_txn_line_id IN NUMBER) IS
2079: SELECT cil.active_end_date active_end_date
2080: ,cil.txn_line_detail_id txn_line_detail_id
2081: FROM csi_t_txn_line_details cil
2082: WHERE cil.transaction_line_id = pc_txn_line_id
2083: AND cil.instance_id IS NULL;
2084:
2085: dummy_rec dummy_csr%rowtype;

Line 2120: FROM csi_t_txn_line_details cil

2116:
2117: CURSOR party_csr (pc_txn_line_id IN NUMBER) IS
2118: SELECT cid.active_start_date active_start_date
2119: ,cid.txn_line_detail_id txn_line_detail_id
2120: FROM csi_t_txn_line_details cil
2121: ,csi_t_party_details cid
2122: WHERE cil.transaction_line_id = pc_txn_line_id
2123: AND cil.instance_id IS NULL
2124: AND cid.txn_line_detail_id = cil.txn_line_detail_id

Line 2172: FROM csi_t_txn_line_details cil

2168: ,cil.instance_status_id instance_status_id
2169: ,cil.external_reference external_reference
2170: ,cil.installation_date installation_date
2171: ,cil.csi_system_id csi_system_id
2172: FROM csi_t_txn_line_details cil
2173: WHERE cil.txn_line_detail_id = pc_txn_line_detail_id
2174: AND cil.instance_id IS NOT NULL;
2175:
2176: txn_det_rec txn_det_csr%rowtype;

Line 2325: FROM csi_t_txn_line_details cil

2321: ,cii.location_type_code location_type_code
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;