DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_I_PRICING_ATTRIBS

Line 3283: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||

3279: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||
3280: ' WHERE a.relationship_id = b.relationship_id AND a.transaction_id = :p_transaction_id '||
3281: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||
3282: ' WHERE a.instance_ou_id = b.instance_ou_id and b.transaction_id = :p_transaction_id '||
3283: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||
3284: ' WHERE a.pricing_attribute_id = b.pricing_attribute_id and b.transaction_id = :p_transaction_id '||
3285: ' UNION SELECT a.instance_id FROM csi_i_version_labels a, csi_i_version_labels_h b '||
3286: ' WHERE a.version_label_id = b.version_label_id and b.transaction_id = :p_transaction_id '||
3287: ' UNION SELECT a.instance_id FROM csi_item_instances a, csi_systems_b b, csi_systems_h c '||

Line 11042: FROM CSI_I_PRICING_ATTRIBS_H CIPAH, CSI_I_PRICING_ATTRIBS CIPA

11038: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11039: UNION ALL
11040:
11041: SELECT CIPAH.TRANSACTION_ID TRANSACTION_ID, CIPA.INSTANCE_ID INSTANCE_ID
11042: FROM CSI_I_PRICING_ATTRIBS_H CIPAH, CSI_I_PRICING_ATTRIBS CIPA
11043: WHERE INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11044: AND CIPAH.PRICING_ATTRIBUTE_ID = CIPA.PRICING_ATTRIBUTE_ID
11045: ) CSA
11046: WHERE CSA.TRANSACTION_ID=CST.TRANSACTION_ID