APPS.CST_XLA_PVT dependencies on CST_XLA_INV_EVENT_MAP

Line 919: FROM cst_xla_inv_event_map

915: -- Leave this transaction src type ID to initial in source_id_int_3
916: nvl( p_trx_info.txn_src_type_id, -1),
917: event_type_code
918: BULK COLLECT INTO l_events
919: FROM cst_xla_inv_event_map
920: WHERE transaction_action_id = p_trx_info.txn_action_id
921: AND ( ( transaction_source_type_id = l_txn_src_type_id ) --p_trx_info.txn_src_type_id
922: /* Added following OR condition for Bug6792259 */
923: OR (l_txn_src_type_id = 8 AND transaction_source_type_id = 7)

Line 927: FROM cst_xla_inv_event_map

923: OR (l_txn_src_type_id = 8 AND transaction_source_type_id = 7)
924: OR( transaction_source_type_id is null
925: AND NOT EXISTS (
926: SELECT 1
927: FROM cst_xla_inv_event_map
928: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
929: AND transaction_action_id = p_trx_info.txn_action_id )
930: )
931: )

Line 950: FROM cst_xla_inv_event_map

946: l_events(1).transaction_id,
947: l_events(1).organization_id,
948: l_events(1).txn_src_type_id,
949: l_events(1).event_type_code
950: FROM cst_xla_inv_event_map
951: WHERE transaction_action_id = p_trx_info.txn_action_id
952: AND transfer_type = DECODE(SIGN(p_trx_info.primary_quantity),-1,'SHIP','RCPT')
953: AND ( ( transaction_source_type_id = l_txn_src_type_id ) --p_trx_info.txn_src_type_id
954: OR( transaction_source_type_id is null

Line 957: FROM cst_xla_inv_event_map

953: AND ( ( transaction_source_type_id = l_txn_src_type_id ) --p_trx_info.txn_src_type_id
954: OR( transaction_source_type_id is null
955: AND NOT EXISTS (
956: SELECT 1
957: FROM cst_xla_inv_event_map
958: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
959: AND transaction_action_id = p_trx_info.txn_action_id )
960: )
961: )

Line 987: FROM cst_xla_inv_event_map

983: l_events(1).transaction_id,
984: l_events(1).organization_id,
985: l_events(1).txn_src_type_id,
986: l_events(1).event_type_code
987: FROM cst_xla_inv_event_map
988: WHERE transaction_action_id = p_trx_info.txn_action_id
989: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id
990: OR( transaction_source_type_id is null
991: AND NOT EXISTS (

Line 993: FROM cst_xla_inv_event_map

989: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id
990: OR( transaction_source_type_id is null
991: AND NOT EXISTS (
992: SELECT 1
993: FROM cst_xla_inv_event_map
994: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
995: AND transaction_action_id = p_trx_info.txn_action_id )
996: )
997: )

Line 1025: FROM cst_xla_inv_event_map

1021: p_trx_info.txn_organization_id ),
1022: nvl( p_trx_info.txn_src_type_id, -1),
1023: event_type_code
1024: BULK COLLECT INTO l_events
1025: FROM cst_xla_inv_event_map
1026: WHERE transaction_action_id = p_trx_info.txn_action_id
1027: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1028: OR( transaction_source_type_id is null
1029: AND NOT EXISTS (

Line 1031: FROM cst_xla_inv_event_map

1027: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1028: OR( transaction_source_type_id is null
1029: AND NOT EXISTS (
1030: SELECT 1
1031: FROM cst_xla_inv_event_map
1032: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1033: AND transaction_action_id = p_trx_info.txn_action_id )
1034: )
1035: )

Line 1059: FROM cst_xla_inv_event_map

1055: INTO l_events(1).transaction_id,
1056: l_events(1).organization_id,
1057: l_events(1).txn_src_type_id,
1058: l_events(1).event_type_code
1059: FROM cst_xla_inv_event_map
1060: WHERE transaction_action_id = p_trx_info.txn_action_id
1061: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1062: OR( transaction_source_type_id is null
1063: AND NOT EXISTS (

Line 1065: FROM cst_xla_inv_event_map

1061: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1062: OR( transaction_source_type_id is null
1063: AND NOT EXISTS (
1064: SELECT 1
1065: FROM cst_xla_inv_event_map
1066: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1067: AND transaction_action_id = p_trx_info.txn_action_id )
1068: )
1069: )

Line 1100: FROM cst_xla_inv_event_map

1096: INTO l_events(1).transaction_id,
1097: l_events(1).organization_id,
1098: l_events(1).txn_src_type_id,
1099: l_events(1).event_type_code
1100: FROM cst_xla_inv_event_map
1101: WHERE transaction_action_id = p_trx_info.txn_action_id
1102: AND ( ( transaction_source_type_id = p_trx_info.txn_src_type_id )
1103: OR( transaction_source_type_id is null
1104: AND NOT EXISTS (

Line 1106: FROM cst_xla_inv_event_map

1102: AND ( ( transaction_source_type_id = p_trx_info.txn_src_type_id )
1103: OR( transaction_source_type_id is null
1104: AND NOT EXISTS (
1105: SELECT 1
1106: FROM cst_xla_inv_event_map
1107: WHERE transaction_source_type_id = p_trx_info.txn_src_type_id
1108: AND transaction_action_id = p_trx_info.txn_action_id )
1109: )
1110: )

Line 1130: FROM cst_xla_inv_event_map

1126: INTO l_events(1).transaction_id,
1127: l_events(1).organization_id,
1128: l_events(1).txn_src_type_id,
1129: l_events(1).event_type_code
1130: FROM cst_xla_inv_event_map
1131: WHERE transaction_action_id = p_trx_info.txn_action_id
1132: AND attribute is null
1133: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1134: OR( transaction_source_type_id is null

Line 1137: FROM cst_xla_inv_event_map

1133: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1134: OR( transaction_source_type_id is null
1135: AND NOT EXISTS (
1136: SELECT 1
1137: FROM cst_xla_inv_event_map
1138: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1139: AND transaction_action_id = p_trx_info.txn_action_id )
1140: )
1141: );