APPS.CST_XLA_PVT dependencies on CST_XLA_INV_EVENT_MAP

Line 1091: FROM cst_xla_inv_event_map

1087: -- Leave this transaction src type ID to initial in source_id_int_3
1088: nvl( p_trx_info.txn_src_type_id, -1),
1089: event_type_code
1090: BULK COLLECT INTO l_events
1091: FROM cst_xla_inv_event_map
1092: WHERE transaction_action_id = p_trx_info.txn_action_id
1093: AND ( ( transaction_source_type_id = l_txn_src_type_id ) --p_trx_info.txn_src_type_id
1094: /* Added following OR condition for Bug6792259 */
1095: OR (l_txn_src_type_id = 8 AND transaction_source_type_id = 7)

Line 1099: FROM cst_xla_inv_event_map

1095: OR (l_txn_src_type_id = 8 AND transaction_source_type_id = 7)
1096: OR( transaction_source_type_id is null
1097: AND NOT EXISTS (
1098: SELECT 1
1099: FROM cst_xla_inv_event_map
1100: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1101: AND transaction_action_id = p_trx_info.txn_action_id )
1102: )
1103: )

Line 1122: FROM cst_xla_inv_event_map

1118: l_events(1).transaction_id,
1119: l_events(1).organization_id,
1120: l_events(1).txn_src_type_id,
1121: l_events(1).event_type_code
1122: FROM cst_xla_inv_event_map
1123: WHERE transaction_action_id = p_trx_info.txn_action_id
1124: AND transfer_type = DECODE(SIGN(p_trx_info.primary_quantity),-1,'SHIP','RCPT')
1125: AND ( ( transaction_source_type_id = l_txn_src_type_id ) --p_trx_info.txn_src_type_id
1126: OR( transaction_source_type_id is null

Line 1129: FROM cst_xla_inv_event_map

1125: AND ( ( transaction_source_type_id = l_txn_src_type_id ) --p_trx_info.txn_src_type_id
1126: OR( transaction_source_type_id is null
1127: AND NOT EXISTS (
1128: SELECT 1
1129: FROM cst_xla_inv_event_map
1130: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1131: AND transaction_action_id = p_trx_info.txn_action_id )
1132: )
1133: )

Line 1159: FROM cst_xla_inv_event_map

1155: l_events(1).transaction_id,
1156: l_events(1).organization_id,
1157: l_events(1).txn_src_type_id,
1158: l_events(1).event_type_code
1159: FROM cst_xla_inv_event_map
1160: WHERE transaction_action_id = p_trx_info.txn_action_id
1161: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id
1162: OR( transaction_source_type_id is null
1163: AND NOT EXISTS (

Line 1165: FROM cst_xla_inv_event_map

1161: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id
1162: OR( transaction_source_type_id is null
1163: AND NOT EXISTS (
1164: SELECT 1
1165: FROM cst_xla_inv_event_map
1166: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1167: AND transaction_action_id = p_trx_info.txn_action_id )
1168: )
1169: )

Line 1197: FROM cst_xla_inv_event_map

1193: p_trx_info.txn_organization_id ),
1194: nvl( p_trx_info.txn_src_type_id, -1),
1195: event_type_code
1196: BULK COLLECT INTO l_events
1197: FROM cst_xla_inv_event_map
1198: WHERE transaction_action_id = p_trx_info.txn_action_id
1199: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1200: OR( transaction_source_type_id is null
1201: AND NOT EXISTS (

Line 1203: FROM cst_xla_inv_event_map

1199: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1200: OR( transaction_source_type_id is null
1201: AND NOT EXISTS (
1202: SELECT 1
1203: FROM cst_xla_inv_event_map
1204: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1205: AND transaction_action_id = p_trx_info.txn_action_id )
1206: )
1207: )

Line 1231: FROM cst_xla_inv_event_map

1227: INTO l_events(1).transaction_id,
1228: l_events(1).organization_id,
1229: l_events(1).txn_src_type_id,
1230: l_events(1).event_type_code
1231: FROM cst_xla_inv_event_map
1232: WHERE transaction_action_id = p_trx_info.txn_action_id
1233: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1234: OR( transaction_source_type_id is null
1235: AND NOT EXISTS (

Line 1237: FROM cst_xla_inv_event_map

1233: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1234: OR( transaction_source_type_id is null
1235: AND NOT EXISTS (
1236: SELECT 1
1237: FROM cst_xla_inv_event_map
1238: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1239: AND transaction_action_id = p_trx_info.txn_action_id )
1240: )
1241: )

Line 1272: FROM cst_xla_inv_event_map

1268: INTO l_events(1).transaction_id,
1269: l_events(1).organization_id,
1270: l_events(1).txn_src_type_id,
1271: l_events(1).event_type_code
1272: FROM cst_xla_inv_event_map
1273: WHERE transaction_action_id = p_trx_info.txn_action_id
1274: AND ( ( transaction_source_type_id = p_trx_info.txn_src_type_id )
1275: OR( transaction_source_type_id is null
1276: AND NOT EXISTS (

Line 1278: FROM cst_xla_inv_event_map

1274: AND ( ( transaction_source_type_id = p_trx_info.txn_src_type_id )
1275: OR( transaction_source_type_id is null
1276: AND NOT EXISTS (
1277: SELECT 1
1278: FROM cst_xla_inv_event_map
1279: WHERE transaction_source_type_id = p_trx_info.txn_src_type_id
1280: AND transaction_action_id = p_trx_info.txn_action_id )
1281: )
1282: )

Line 1302: FROM cst_xla_inv_event_map

1298: INTO l_events(1).transaction_id,
1299: l_events(1).organization_id,
1300: l_events(1).txn_src_type_id,
1301: l_events(1).event_type_code
1302: FROM cst_xla_inv_event_map
1303: WHERE transaction_action_id = p_trx_info.txn_action_id
1304: AND attribute is null
1305: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1306: OR( transaction_source_type_id is null

Line 1309: FROM cst_xla_inv_event_map

1305: AND ( ( transaction_source_type_id = l_txn_src_type_id) --p_trx_info.txn_src_type_id )
1306: OR( transaction_source_type_id is null
1307: AND NOT EXISTS (
1308: SELECT 1
1309: FROM cst_xla_inv_event_map
1310: WHERE transaction_source_type_id = l_txn_src_type_id --p_trx_info.txn_src_type_id
1311: AND transaction_action_id = p_trx_info.txn_action_id )
1312: )
1313: );