[Home] [Help]
57: inv_log_util.TRACE('** Trans Eres Enabled trx_action_id = ' || p_trans_action_id, 'INV_LPN_TRX_PUB', 9);
58: inv_log_util.TRACE('** Trans Eres Enabled trx_soource_id =' || p_trans_source_type_id, 'INV_LPN_TRX_PUB', 9);
59: END IF;
60:
61: IF (p_trans_action_id NOT IN(inv_globals.g_action_issue, inv_globals.g_action_receipt,INV_GLOBALS.G_ACTION_SUBXFR,
62: INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN
63: inv_log_util.TRACE(
64: '** Transactions Not ERES Supported trx_action_id =' || p_trans_action_id || ',trx_source_type_id =' || p_trans_source_type_id
65: , 'INV_LPN_TRX_PUB'
58: inv_log_util.TRACE('** Trans Eres Enabled trx_soource_id =' || p_trans_source_type_id, 'INV_LPN_TRX_PUB', 9);
59: END IF;
60:
61: IF (p_trans_action_id NOT IN(inv_globals.g_action_issue, inv_globals.g_action_receipt,INV_GLOBALS.G_ACTION_SUBXFR,
62: INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN
63: inv_log_util.TRACE(
64: '** Transactions Not ERES Supported trx_action_id =' || p_trans_action_id || ',trx_source_type_id =' || p_trans_source_type_id
65: , 'INV_LPN_TRX_PUB'
66: , 9
65: , 'INV_LPN_TRX_PUB'
66: , 9
67: );
68: RETURN FALSE;
69: ELSIF(p_trans_action_id = inv_globals.g_action_issue) THEN
70: -- These are Issue trans types
71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
72: g_eres_event_name := 'oracle.apps.inv.acctIssue';
73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
67: );
68: RETURN FALSE;
69: ELSIF(p_trans_action_id = inv_globals.g_action_issue) THEN
70: -- These are Issue trans types
71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
72: g_eres_event_name := 'oracle.apps.inv.acctIssue';
73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
74: g_eres_event_name := 'oracle.apps.inv.acctAliasIssue';
75: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
69: ELSIF(p_trans_action_id = inv_globals.g_action_issue) THEN
70: -- These are Issue trans types
71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
72: g_eres_event_name := 'oracle.apps.inv.acctIssue';
73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
74: g_eres_event_name := 'oracle.apps.inv.acctAliasIssue';
75: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
76: g_eres_event_name := 'oracle.apps.inv.miscIssue';
77: ELSE
71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
72: g_eres_event_name := 'oracle.apps.inv.acctIssue';
73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
74: g_eres_event_name := 'oracle.apps.inv.acctAliasIssue';
75: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
76: g_eres_event_name := 'oracle.apps.inv.miscIssue';
77: ELSE
78: RETURN FALSE;
79: END IF;
76: g_eres_event_name := 'oracle.apps.inv.miscIssue';
77: ELSE
78: RETURN FALSE;
79: END IF;
80: ELSIF(p_trans_action_id = inv_globals.g_action_receipt) THEN
81: -- These are Reciept trans types
82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
83: g_eres_event_name := 'oracle.apps.inv.acctReceipt';
84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
78: RETURN FALSE;
79: END IF;
80: ELSIF(p_trans_action_id = inv_globals.g_action_receipt) THEN
81: -- These are Reciept trans types
82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
83: g_eres_event_name := 'oracle.apps.inv.acctReceipt';
84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
85: g_eres_event_name := 'oracle.apps.inv.acctAliasReceipt';
86: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
80: ELSIF(p_trans_action_id = inv_globals.g_action_receipt) THEN
81: -- These are Reciept trans types
82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
83: g_eres_event_name := 'oracle.apps.inv.acctReceipt';
84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
85: g_eres_event_name := 'oracle.apps.inv.acctAliasReceipt';
86: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
87: g_eres_event_name := 'oracle.apps.inv.miscReceipt';
88: ELSE
82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
83: g_eres_event_name := 'oracle.apps.inv.acctReceipt';
84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
85: g_eres_event_name := 'oracle.apps.inv.acctAliasReceipt';
86: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
87: g_eres_event_name := 'oracle.apps.inv.miscReceipt';
88: ELSE
89: RETURN FALSE;
90: END IF;
88: ELSE
89: RETURN FALSE;
90: END IF;
91: -- fabdi invconv start
92: ELSIF (p_trans_action_id = INV_GLOBALS.G_ACTION_SUBXFR) THEN
93: -- These are Inter-Org Transfers trans types
94: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN
95: g_eres_event_name := 'oracle.apps.inv.subinvTransfer';
96: ELSE
90: END IF;
91: -- fabdi invconv start
92: ELSIF (p_trans_action_id = INV_GLOBALS.G_ACTION_SUBXFR) THEN
93: -- These are Inter-Org Transfers trans types
94: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN
95: g_eres_event_name := 'oracle.apps.inv.subinvTransfer';
96: ELSE
97: RETURN FALSE;
98: END IF;
95: g_eres_event_name := 'oracle.apps.inv.subinvTransfer';
96: ELSE
97: RETURN FALSE;
98: END IF;
99: ELSIF (p_trans_action_id in (INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN
100: -- These are Subinventory Transfers trans types
101: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN
102: g_eres_event_name := 'oracle.apps.inv.interorgTransfer';
103: ELSE
97: RETURN FALSE;
98: END IF;
99: ELSIF (p_trans_action_id in (INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN
100: -- These are Subinventory Transfers trans types
101: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN
102: g_eres_event_name := 'oracle.apps.inv.interorgTransfer';
103: ELSE
104: RETURN FALSE;
105: END IF;
244: -- If the transaction action is OrgXfr, IntrShipment or IntrRcpt
245: -- then set the cost_group_id to null. The CostGroup API will
246: -- determine the cost-group-id in this case. Insert into MMTT using
247: -- the passed MMTT_Record type.
248: IF (v_trxaction = inv_globals.g_action_orgxfr)
249: OR(v_trxaction = inv_globals.g_action_intransitshipment)
250: OR(v_trxaction = inv_globals.g_action_intransitreceipt) THEN
251: l_xfr_cst_grp_id := NULL;
252: END IF;
245: -- then set the cost_group_id to null. The CostGroup API will
246: -- determine the cost-group-id in this case. Insert into MMTT using
247: -- the passed MMTT_Record type.
248: IF (v_trxaction = inv_globals.g_action_orgxfr)
249: OR(v_trxaction = inv_globals.g_action_intransitshipment)
250: OR(v_trxaction = inv_globals.g_action_intransitreceipt) THEN
251: l_xfr_cst_grp_id := NULL;
252: END IF;
253:
246: -- determine the cost-group-id in this case. Insert into MMTT using
247: -- the passed MMTT_Record type.
248: IF (v_trxaction = inv_globals.g_action_orgxfr)
249: OR(v_trxaction = inv_globals.g_action_intransitshipment)
250: OR(v_trxaction = inv_globals.g_action_intransitreceipt) THEN
251: l_xfr_cst_grp_id := NULL;
252: END IF;
253:
254: -- Added two columns to MMTT for International drop shipments -
712: END IF;
713:
714: -- Bug 2712046, add cost group comingle check if transfer location is non-LPN controlled
715: -- Set value for l_check_cg_comingle, this only need to be checked once before the Loop
716: IF (p_mmtt.transaction_action_id <> inv_globals.g_action_orgxfr)
717: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitshipment)
718: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)
719: AND(NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code) IS NOT NULL) THEN
720: SELECT NVL(lpn_controlled_flag, 2)
713:
714: -- Bug 2712046, add cost group comingle check if transfer location is non-LPN controlled
715: -- Set value for l_check_cg_comingle, this only need to be checked once before the Loop
716: IF (p_mmtt.transaction_action_id <> inv_globals.g_action_orgxfr)
717: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitshipment)
718: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)
719: AND(NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code) IS NOT NULL) THEN
720: SELECT NVL(lpn_controlled_flag, 2)
721: INTO l_skip_comingle_check
714: -- Bug 2712046, add cost group comingle check if transfer location is non-LPN controlled
715: -- Set value for l_check_cg_comingle, this only need to be checked once before the Loop
716: IF (p_mmtt.transaction_action_id <> inv_globals.g_action_orgxfr)
717: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitshipment)
718: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)
719: AND(NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code) IS NOT NULL) THEN
720: SELECT NVL(lpn_controlled_flag, 2)
721: INTO l_skip_comingle_check
722: FROM mtl_secondary_inventories
1046: -- End Bug 2712046
1047:
1048: -- if the previous item's qty was changed, then update record
1049: IF (itemqtychanged) THEN
1050: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1051: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment) THEN
1052: v_lastitemqty := -1 * v_lastitemqty;
1053:
1054: IF v_lastitemsecqty <> 0 THEN -- INVCONV KKILLAMS
1047:
1048: -- if the previous item's qty was changed, then update record
1049: IF (itemqtychanged) THEN
1050: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1051: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment) THEN
1052: v_lastitemqty := -1 * v_lastitemqty;
1053:
1054: IF v_lastitemsecqty <> 0 THEN -- INVCONV KKILLAMS
1055: v_lastitemsecqty := -1 * v_lastitemsecqty;
1088: -- If this an InterOrg Xfer transaction, then call the CostGroup API
1089: -- for the previously entered content Item. At this stage all the
1090: -- rows for this item would have been entered to the temp tables.
1091: IF (lastitemid IS NOT NULL) THEN
1092: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1093: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1094: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1095: OR
1096: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1089: -- for the previously entered content Item. At this stage all the
1090: -- rows for this item would have been entered to the temp tables.
1091: IF (lastitemid IS NOT NULL) THEN
1092: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1093: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1094: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1095: OR
1096: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1097: -- Changed to add the condition that if cost group ID is null then also need to call cost group API
1090: -- rows for this item would have been entered to the temp tables.
1091: IF (lastitemid IS NOT NULL) THEN
1092: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1093: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1094: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1095: OR
1096: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1097: -- Changed to add the condition that if cost group ID is null then also need to call cost group API
1098: ( p_mmtt.cost_group_id IS NULL) THEN
1131: v_lastitemqty := curlpnrec.quantity;
1132: v_lastitemsecqty := curlpnrec.sec_quantity; --INVCONV kkillams
1133:
1134: -- insert a record into MMTT.
1135: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1136: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1137: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1138: AND(p_mmtt.transaction_quantity < 0)) THEN
1139: itemqty := -1 * curlpnrec.quantity;
1132: v_lastitemsecqty := curlpnrec.sec_quantity; --INVCONV kkillams
1133:
1134: -- insert a record into MMTT.
1135: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1136: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1137: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1138: AND(p_mmtt.transaction_quantity < 0)) THEN
1139: itemqty := -1 * curlpnrec.quantity;
1140: itemsecqty := -1 * curlpnrec.sec_quantity; --INVCONV kkillams
1133:
1134: -- insert a record into MMTT.
1135: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1136: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1137: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1138: AND(p_mmtt.transaction_quantity < 0)) THEN
1139: itemqty := -1 * curlpnrec.quantity;
1140: itemsecqty := -1 * curlpnrec.sec_quantity; --INVCONV kkillams
1141: ELSE
1217: END LOOP;
1218:
1219: -- Any item or lot qty need to be updated ??
1220: IF (itemqtychanged) THEN
1221: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1222: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1223: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1224: AND(p_mmtt.transaction_quantity < 0)) THEN
1225: v_lastitemqty := -1 * v_lastitemqty;
1218:
1219: -- Any item or lot qty need to be updated ??
1220: IF (itemqtychanged) THEN
1221: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1222: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1223: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1224: AND(p_mmtt.transaction_quantity < 0)) THEN
1225: v_lastitemqty := -1 * v_lastitemqty;
1226: IF v_lastitemsecqty IS NOT NULL THEN
1219: -- Any item or lot qty need to be updated ??
1220: IF (itemqtychanged) THEN
1221: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1222: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1223: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1224: AND(p_mmtt.transaction_quantity < 0)) THEN
1225: v_lastitemqty := -1 * v_lastitemqty;
1226: IF v_lastitemsecqty IS NOT NULL THEN
1227: v_lastitemsecqty := -1 * v_lastitemsecqty; --INVCONV kkillams
1254:
1255: -- If this an InterOrg Xfer transaction, then call the CostGroup API
1256: -- for the previously entered content Item. At this stage all the
1257: -- rows for this item would have been entered to the temp tables.
1258: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1259: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1260: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1261: OR
1262: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1255: -- If this an InterOrg Xfer transaction, then call the CostGroup API
1256: -- for the previously entered content Item. At this stage all the
1257: -- rows for this item would have been entered to the temp tables.
1258: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1259: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1260: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1261: OR
1262: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1263: -- Changed to add the condition that if cost group ID is null then also need to call cost group API
1256: -- for the previously entered content Item. At this stage all the
1257: -- rows for this item would have been entered to the temp tables.
1258: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1259: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1260: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1261: OR
1262: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1263: -- Changed to add the condition that if cost group ID is null then also need to call cost group API
1264: ( p_mmtt.cost_group_id IS NULL) THEN
1327:
1328: RETURN;
1329: END IF;
1330:
1331: IF (v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment) THEN
1332: BEGIN
1333: SELECT fob_point
1334: , intransit_inv_account
1335: INTO l_fob_point
1356:
1357: /**bug 3371548 assign values to the cursor*/
1358: v_mmtt.fob_point := l_fob_point;
1359: v_mmtt.intransit_account := l_intransit_inv_account;
1360: ELSIF(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt) THEN
1361: BEGIN
1362: SELECT shipment_line_id
1363: INTO l_shipment_line_id
1364: FROM rcv_transactions
1492:
1493: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1494: BEGIN
1495: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1496: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1497: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)
1498: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)
1499: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))
1500: THEN
1493: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1494: BEGIN
1495: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1496: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1497: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)
1498: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)
1499: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))
1500: THEN
1501: -- For the above types ignore the item controls
1494: BEGIN
1495: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1496: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1497: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)
1498: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)
1499: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))
1500: THEN
1501: -- For the above types ignore the item controls
1502: l_ignore_item_controls := 1;
1495: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1496: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1497: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)
1498: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)
1499: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))
1500: THEN
1501: -- For the above types ignore the item controls
1502: l_ignore_item_controls := 1;
1503: ELSE
3354: from mtl_system_items_b msib
3355: where msib.inventory_item_id = mmt.inventory_item_id
3356: and msib.organization_id = mmt.organization_id
3357: and msib.process_quality_enabled_flag = 'Y')
3358: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3359: ,inv_globals.g_action_receipt
3360: ,inv_globals.g_action_subxfr
3361: ,inv_globals.g_action_orgxfr
3362: ,inv_globals.g_action_intransitshipment
3355: where msib.inventory_item_id = mmt.inventory_item_id
3356: and msib.organization_id = mmt.organization_id
3357: and msib.process_quality_enabled_flag = 'Y')
3358: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3359: ,inv_globals.g_action_receipt
3360: ,inv_globals.g_action_subxfr
3361: ,inv_globals.g_action_orgxfr
3362: ,inv_globals.g_action_intransitshipment
3363: ,inv_globals.g_action_intransitreceipt))
3356: and msib.organization_id = mmt.organization_id
3357: and msib.process_quality_enabled_flag = 'Y')
3358: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3359: ,inv_globals.g_action_receipt
3360: ,inv_globals.g_action_subxfr
3361: ,inv_globals.g_action_orgxfr
3362: ,inv_globals.g_action_intransitshipment
3363: ,inv_globals.g_action_intransitreceipt))
3364: --Bug#6509707.Included Account Alias Receipt.
3357: and msib.process_quality_enabled_flag = 'Y')
3358: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3359: ,inv_globals.g_action_receipt
3360: ,inv_globals.g_action_subxfr
3361: ,inv_globals.g_action_orgxfr
3362: ,inv_globals.g_action_intransitshipment
3363: ,inv_globals.g_action_intransitreceipt))
3364: --Bug#6509707.Included Account Alias Receipt.
3365: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3358: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3359: ,inv_globals.g_action_receipt
3360: ,inv_globals.g_action_subxfr
3361: ,inv_globals.g_action_orgxfr
3362: ,inv_globals.g_action_intransitshipment
3363: ,inv_globals.g_action_intransitreceipt))
3364: --Bug#6509707.Included Account Alias Receipt.
3365: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3366: ) )
3359: ,inv_globals.g_action_receipt
3360: ,inv_globals.g_action_subxfr
3361: ,inv_globals.g_action_orgxfr
3362: ,inv_globals.g_action_intransitshipment
3363: ,inv_globals.g_action_intransitreceipt))
3364: --Bug#6509707.Included Account Alias Receipt.
3365: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3366: ) )
3367: -- Pawan Kumar added bug 5533472
3361: ,inv_globals.g_action_orgxfr
3362: ,inv_globals.g_action_intransitshipment
3363: ,inv_globals.g_action_intransitreceipt))
3364: --Bug#6509707.Included Account Alias Receipt.
3365: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3366: ) )
3367: -- Pawan Kumar added bug 5533472
3368: OR (
3369: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)
3365: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3366: ) )
3367: -- Pawan Kumar added bug 5533472
3368: OR (
3369: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)
3370: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)
3371: )
3372: OR (
3373: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3366: ) )
3367: -- Pawan Kumar added bug 5533472
3368: OR (
3369: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)
3370: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)
3371: )
3372: OR (
3373: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3374: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3369: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)
3370: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)
3371: )
3372: OR (
3373: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3374: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3375: )
3376: OR (
3377: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)
3370: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)
3371: )
3372: OR (
3373: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3374: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3375: )
3376: OR (
3377: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)
3378: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_physicalcount)
3373: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3374: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3375: )
3376: OR (
3377: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)
3378: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_physicalcount)
3379: )
3380:
3381: )
3374: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3375: )
3376: OR (
3377: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)
3378: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_physicalcount)
3379: )
3380:
3381: )
3382: AND (exists (select gisv.spec_id
3387: and gisv.spec_id = gsb.spec_id
3388: and gisv.delete_mark = 0
3389: and (gisv.organization_id is null OR gisv.organization_id = mmt.organization_id)))
3390: )
3391: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)
3392: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3393: ,inv_globals.g_sourcetype_rma
3394: ,inv_globals.g_sourcetype_intreq))
3395: AND ( (exists (select gssv.spec_id
3388: and gisv.delete_mark = 0
3389: and (gisv.organization_id is null OR gisv.organization_id = mmt.organization_id)))
3390: )
3391: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)
3392: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3393: ,inv_globals.g_sourcetype_rma
3394: ,inv_globals.g_sourcetype_intreq))
3395: AND ( (exists (select gssv.spec_id
3396: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb
3389: and (gisv.organization_id is null OR gisv.organization_id = mmt.organization_id)))
3390: )
3391: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)
3392: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3393: ,inv_globals.g_sourcetype_rma
3394: ,inv_globals.g_sourcetype_intreq))
3395: AND ( (exists (select gssv.spec_id
3396: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb
3397: where gsb.inventory_item_id = mmt.inventory_item_id
3390: )
3391: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)
3392: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3393: ,inv_globals.g_sourcetype_rma
3394: ,inv_globals.g_sourcetype_intreq))
3395: AND ( (exists (select gssv.spec_id
3396: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb
3397: where gsb.inventory_item_id = mmt.inventory_item_id
3398: and gsb.spec_status in (400,700)
3572: FROM DUAL
3573: WHERE EXISTS(
3574: SELECT 1
3575: FROM mtl_material_transactions_temp
3576: WHERE transaction_action_id = inv_globals.g_action_containerpack
3577: AND transfer_lpn_id IS NULL
3578: AND transaction_header_id = p_trx_hdr_id);
3579: EXCEPTION
3580: WHEN NO_DATA_FOUND THEN
3792: | adjustment to go through TM for lot serial support
3793: +------------------------------------------------------*/
3794: IF (
3795: (
3796: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
3797: AND v_mmtt.transaction_action_id IN
3798: (
3799: inv_globals.g_action_logicalissue
3800: , inv_globals.g_action_logicalicsales
3795: (
3796: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
3797: AND v_mmtt.transaction_action_id IN
3798: (
3799: inv_globals.g_action_logicalissue
3800: , inv_globals.g_action_logicalicsales
3801: , inv_globals.g_action_logicalicreceipt
3802: , inv_globals.g_action_logicalicrcptreturn
3803: , inv_globals.g_action_logicalicsalesreturn
3796: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
3797: AND v_mmtt.transaction_action_id IN
3798: (
3799: inv_globals.g_action_logicalissue
3800: , inv_globals.g_action_logicalicsales
3801: , inv_globals.g_action_logicalicreceipt
3802: , inv_globals.g_action_logicalicrcptreturn
3803: , inv_globals.g_action_logicalicsalesreturn
3804: , inv_globals.g_action_logicalreceipt
3797: AND v_mmtt.transaction_action_id IN
3798: (
3799: inv_globals.g_action_logicalissue
3800: , inv_globals.g_action_logicalicsales
3801: , inv_globals.g_action_logicalicreceipt
3802: , inv_globals.g_action_logicalicrcptreturn
3803: , inv_globals.g_action_logicalicsalesreturn
3804: , inv_globals.g_action_logicalreceipt
3805: )
3798: (
3799: inv_globals.g_action_logicalissue
3800: , inv_globals.g_action_logicalicsales
3801: , inv_globals.g_action_logicalicreceipt
3802: , inv_globals.g_action_logicalicrcptreturn
3803: , inv_globals.g_action_logicalicsalesreturn
3804: , inv_globals.g_action_logicalreceipt
3805: )
3806: )
3799: inv_globals.g_action_logicalissue
3800: , inv_globals.g_action_logicalicsales
3801: , inv_globals.g_action_logicalicreceipt
3802: , inv_globals.g_action_logicalicrcptreturn
3803: , inv_globals.g_action_logicalicsalesreturn
3804: , inv_globals.g_action_logicalreceipt
3805: )
3806: )
3807: OR(
3800: , inv_globals.g_action_logicalicsales
3801: , inv_globals.g_action_logicalicreceipt
3802: , inv_globals.g_action_logicalicrcptreturn
3803: , inv_globals.g_action_logicalicsalesreturn
3804: , inv_globals.g_action_logicalreceipt
3805: )
3806: )
3807: OR(
3808: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3804: , inv_globals.g_action_logicalreceipt
3805: )
3806: )
3807: OR(
3808: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3809: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3810: )
3811: OR(
3812: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
3805: )
3806: )
3807: OR(
3808: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3809: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3810: )
3811: OR(
3812: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
3813: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
3808: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3809: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3810: )
3811: OR(
3812: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
3813: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
3814: -- inv_globals.G_action_logicaldeladj,
3815: -- inv_globals.G_action_logicalreceipt,
3816: inv_globals.g_action_retropriceupdate)
3809: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3810: )
3811: OR(
3812: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
3813: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
3814: -- inv_globals.G_action_logicaldeladj,
3815: -- inv_globals.G_action_logicalreceipt,
3816: inv_globals.g_action_retropriceupdate)
3817: )
3810: )
3811: OR(
3812: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
3813: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
3814: -- inv_globals.G_action_logicaldeladj,
3815: -- inv_globals.G_action_logicalreceipt,
3816: inv_globals.g_action_retropriceupdate)
3817: )
3818: OR(
3811: OR(
3812: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
3813: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
3814: -- inv_globals.G_action_logicaldeladj,
3815: -- inv_globals.G_action_logicalreceipt,
3816: inv_globals.g_action_retropriceupdate)
3817: )
3818: OR(
3819: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3812: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
3813: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
3814: -- inv_globals.G_action_logicaldeladj,
3815: -- inv_globals.G_action_logicalreceipt,
3816: inv_globals.g_action_retropriceupdate)
3817: )
3818: OR(
3819: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3820: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3815: -- inv_globals.G_action_logicalreceipt,
3816: inv_globals.g_action_retropriceupdate)
3817: )
3818: OR(
3819: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3820: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3821: )
3822: OR(
3823: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
3816: inv_globals.g_action_retropriceupdate)
3817: )
3818: OR(
3819: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3820: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3821: )
3822: OR(
3823: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
3824: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
3819: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
3820: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3821: )
3822: OR(
3823: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
3824: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
3825: )
3826: OR(
3827: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3820: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
3821: )
3822: OR(
3823: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
3824: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
3825: )
3826: OR(
3827: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3828: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue
3823: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
3824: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
3825: )
3826: OR(
3827: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3828: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue
3829: )
3830: ) THEN
3831: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
3824: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
3825: )
3826: OR(
3827: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3828: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue
3829: )
3830: ) THEN
3831: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
3832: fnd_msg_pub.ADD;
3858: --For any transaction in mmtt which is an explicit transaction,
3859: --implying that the owning_org or planning_org is populated in
3860: --mmtt make sure the transactions are alwaya processed in online
3861: -- mode bug 3691234
3862: IF ((v_mmtt.transaction_action_id = inv_globals.g_action_planxfr)
3863: OR(v_mmtt.transaction_action_id = inv_globals.g_action_ownxfr)
3864: OR (Nvl(v_mmtt.owning_organization_id,v_mmtt.organization_id)
3865: <> v_mmtt.organization_id)
3866: OR (Nvl(v_mmtt.planning_organization_id,v_mmtt.organization_id)
3859: --implying that the owning_org or planning_org is populated in
3860: --mmtt make sure the transactions are alwaya processed in online
3861: -- mode bug 3691234
3862: IF ((v_mmtt.transaction_action_id = inv_globals.g_action_planxfr)
3863: OR(v_mmtt.transaction_action_id = inv_globals.g_action_ownxfr)
3864: OR (Nvl(v_mmtt.owning_organization_id,v_mmtt.organization_id)
3865: <> v_mmtt.organization_id)
3866: OR (Nvl(v_mmtt.planning_organization_id,v_mmtt.organization_id)
3867: <> v_mmtt.organization_id)) THEN
3871: -- If l_proc_mode is not set at this stage, it means control is at
3872: -- Forms-level Transaction-process profiles based on Transaction
3873: IF (l_proc_mode IS NULL) THEN
3874: IF (
3875: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3876: AND(v_mmtt.transaction_action_id = inv_globals.g_action_subxfr)
3877: ) THEN
3878: l_proc_mode := fnd_profile.VALUE('SUBINV_TRANS_TXN');
3879:
3872: -- Forms-level Transaction-process profiles based on Transaction
3873: IF (l_proc_mode IS NULL) THEN
3874: IF (
3875: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3876: AND(v_mmtt.transaction_action_id = inv_globals.g_action_subxfr)
3877: ) THEN
3878: l_proc_mode := fnd_profile.VALUE('SUBINV_TRANS_TXN');
3879:
3880: IF (l_debug = 1) THEN
3881: inv_log_util.TRACE('Using SUBINV_TRANS_TXN to set process_mode. ProcMode=' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3882: END IF;
3883: ELSIF(
3884: (
3885: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3886: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)
3887: )
3888: AND(
3889: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3882: END IF;
3883: ELSIF(
3884: (
3885: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3886: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)
3887: )
3888: AND(
3889: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3890: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
3885: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3886: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)
3887: )
3888: AND(
3889: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3890: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
3891: )
3892: ) THEN
3893: l_proc_mode := fnd_profile.VALUE('ACCOUNT_ISSUE_TXN');
3886: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)
3887: )
3888: AND(
3889: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3890: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
3891: )
3892: ) THEN
3893: l_proc_mode := fnd_profile.VALUE('ACCOUNT_ISSUE_TXN');
3894:
3895: IF (l_debug = 1) THEN
3896: inv_log_util.TRACE('Using ACCOUNT_ISSUE_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3897: END IF;
3898: ELSIF(
3899: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3900: AND(
3901: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
3902: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3903: )
3897: END IF;
3898: ELSIF(
3899: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3900: AND(
3901: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
3902: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3903: )
3904: ) THEN
3905: l_proc_mode := fnd_profile.VALUE('TRANSFER_ORDER_TXN');
3898: ELSIF(
3899: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3900: AND(
3901: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
3902: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3903: )
3904: ) THEN
3905: l_proc_mode := fnd_profile.VALUE('TRANSFER_ORDER_TXN');
3906:
3907: IF (l_debug = 1) THEN
3908: inv_log_util.TRACE('Using TRANSFER_ORDER_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3909: END IF;
3910: ELSIF(
3911: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3912: AND(
3913: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
3914: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
3915: )
3909: END IF;
3910: ELSIF(
3911: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3912: AND(
3913: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
3914: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
3915: )
3916: ) THEN
3917: l_proc_mode := fnd_profile.VALUE('INTER_ORG_SHIP_TXN');
3910: ELSIF(
3911: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3912: AND(
3913: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
3914: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
3915: )
3916: ) THEN
3917: l_proc_mode := fnd_profile.VALUE('INTER_ORG_SHIP_TXN');
3918:
3949: -- mmtt record with the fob_point and inv_intransit_account in
3950: -- case of an intransit Rcpt or intransit Shipment transaction
3951: IF (po_code_release_grp.current_release >= po_code_release_grp.prc_11i_family_pack_j) THEN
3952: IF (
3953: (v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
3954: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
3955: ) THEN
3956: update_fob_point(v_mmtt => v_mmtt, x_return_status => l_fob_ret_sts, x_msg_data => l_fob_ret_msg
3957: , x_msg_count => l_fob_msg_count);
3950: -- case of an intransit Rcpt or intransit Shipment transaction
3951: IF (po_code_release_grp.current_release >= po_code_release_grp.prc_11i_family_pack_j) THEN
3952: IF (
3953: (v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
3954: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
3955: ) THEN
3956: update_fob_point(v_mmtt => v_mmtt, x_return_status => l_fob_ret_sts, x_msg_data => l_fob_ret_msg
3957: , x_msg_count => l_fob_msg_count);
3958:
3998: -- is neither S.O nor I.O
3999: IF NOT(
4000: (v_mmtt.content_lpn_id IS NOT NULL)
4001: AND
4002: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder
4003: AND
4004: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
4005: ) THEN
4006: inv_cost_group_pvt.assign_cost_group(
4000: (v_mmtt.content_lpn_id IS NOT NULL)
4001: AND
4002: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder
4003: AND
4004: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
4005: ) THEN
4006: inv_cost_group_pvt.assign_cost_group(
4007: x_return_status => ret_status
4008: , x_msg_count => ret_msgcnt
4087: -- the sign of quantity is not -ve, make it -ve.
4088: -- Bug 3736797, added update to MMTT, since MMTT was never getting updated with sign changed.
4089: IF (
4090: (
4091: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4092: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4093: )
4094: AND(v_mmtt.primary_quantity > 0)
4095: ) THEN
4088: -- Bug 3736797, added update to MMTT, since MMTT was never getting updated with sign changed.
4089: IF (
4090: (
4091: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4092: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4093: )
4094: AND(v_mmtt.primary_quantity > 0)
4095: ) THEN
4096:
4147: -- Note: For SO and IO transactions, there is no need
4148: -- to explode the LPN as there will be a seperate MMTT line for each
4149: -- item inside the LPN
4150: IF (v_mmtt.content_lpn_id IS NOT NULL) THEN
4151: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4152: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4153: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4154: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4155: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4148: -- to explode the LPN as there will be a seperate MMTT line for each
4149: -- item inside the LPN
4150: IF (v_mmtt.content_lpn_id IS NOT NULL) THEN
4151: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4152: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4153: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4154: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4155: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4156: l_putway_explode_req = 'N' )
4149: -- item inside the LPN
4150: IF (v_mmtt.content_lpn_id IS NOT NULL) THEN
4151: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4152: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4153: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4154: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4155: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4156: l_putway_explode_req = 'N' )
4157: THEN
4150: IF (v_mmtt.content_lpn_id IS NOT NULL) THEN
4151: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4152: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4153: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4154: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4155: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4156: l_putway_explode_req = 'N' )
4157: THEN
4158: expldrowcnt := explode_and_insert(v_mmtt.content_lpn_id, p_trx_hdr_id, v_mmtt);
4151: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4152: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4153: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4154: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4155: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4156: l_putway_explode_req = 'N' )
4157: THEN
4158: expldrowcnt := explode_and_insert(v_mmtt.content_lpn_id, p_trx_hdr_id, v_mmtt);
4159:
4598: FOR c1_rec IN cur_get_txn_for_opm_qm
4599: LOOP
4600: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
4601: ,p_event_key => c1_rec.transaction_id);
4602: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
4603: ,inv_globals.g_sourcetype_rma
4604: ,inv_globals.g_sourcetype_intreq) THEN
4605: /* Bug 5361705 - Raise the opm qm quality event for every distinct lot */
4606: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)
4599: LOOP
4600: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
4601: ,p_event_key => c1_rec.transaction_id);
4602: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
4603: ,inv_globals.g_sourcetype_rma
4604: ,inv_globals.g_sourcetype_intreq) THEN
4605: /* Bug 5361705 - Raise the opm qm quality event for every distinct lot */
4606: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)
4607: LOOP
4600: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
4601: ,p_event_key => c1_rec.transaction_id);
4602: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
4603: ,inv_globals.g_sourcetype_rma
4604: ,inv_globals.g_sourcetype_intreq) THEN
4605: /* Bug 5361705 - Raise the opm qm quality event for every distinct lot */
4606: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)
4607: LOOP
4608:
4929: -- If the transaction action is either Issue or Intransit Shipment, and
4930: -- the sign of quantity is not -ve, make it -ve.
4931: IF (
4932: (
4933: (p_transaction_action_id = inv_globals.g_action_issue)
4934: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4935: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4936: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4937: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4930: -- the sign of quantity is not -ve, make it -ve.
4931: IF (
4932: (
4933: (p_transaction_action_id = inv_globals.g_action_issue)
4934: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4935: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4936: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4937: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4938: )
4931: IF (
4932: (
4933: (p_transaction_action_id = inv_globals.g_action_issue)
4934: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4935: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4936: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4937: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4938: )
4939: AND(p_primary_quantity > 0)
4932: (
4933: (p_transaction_action_id = inv_globals.g_action_issue)
4934: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4935: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4936: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4937: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4938: )
4939: AND(p_primary_quantity > 0)
4940: ) THEN
4933: (p_transaction_action_id = inv_globals.g_action_issue)
4934: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4935: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4936: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4937: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
4938: )
4939: AND(p_primary_quantity > 0)
4940: ) THEN
4941: l_primary_quantity := -1 * p_primary_quantity;
4946: END IF;
4947:
4948: IF (
4949: (
4950: (p_transaction_action_id = inv_globals.g_action_subxfr)
4951: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
4952: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
4953: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
4954: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
4947:
4948: IF (
4949: (
4950: (p_transaction_action_id = inv_globals.g_action_subxfr)
4951: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
4952: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
4953: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
4954: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
4955: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
4948: IF (
4949: (
4950: (p_transaction_action_id = inv_globals.g_action_subxfr)
4951: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
4952: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
4953: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
4954: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
4955: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
4956: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
4949: (
4950: (p_transaction_action_id = inv_globals.g_action_subxfr)
4951: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
4952: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
4953: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
4954: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
4955: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
4956: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
4957: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
4950: (p_transaction_action_id = inv_globals.g_action_subxfr)
4951: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
4952: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
4953: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
4954: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
4955: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
4956: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
4957: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
4958: )
4951: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
4952: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
4953: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
4954: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
4955: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
4956: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
4957: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
4958: )
4959: AND(p_primary_quantity < 0)
4952: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
4953: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
4954: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
4955: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
4956: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
4957: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
4958: )
4959: AND(p_primary_quantity < 0)
4960: ) THEN
4953: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
4954: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
4955: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
4956: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
4957: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
4958: )
4959: AND(p_primary_quantity < 0)
4960: ) THEN
4961: l_primary_quantity := -1 * p_primary_quantity;
4971: -- IDS: Logical Transactions for lot and serials - Opened up TM to
4972: -- handle logical receipts and logical corrections.
4973: IF (
4974: (
4975: p_transaction_action_id = inv_globals.g_action_deliveryadj
4976: AND(
4977: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4978: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
4979: )
4973: IF (
4974: (
4975: p_transaction_action_id = inv_globals.g_action_deliveryadj
4976: AND(
4977: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4978: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
4979: )
4980: )
4981: OR(
4974: (
4975: p_transaction_action_id = inv_globals.g_action_deliveryadj
4976: AND(
4977: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4978: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
4979: )
4980: )
4981: OR(
4982: p_transaction_action_id = inv_globals.g_action_logicaldeladj
4978: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
4979: )
4980: )
4981: OR(
4982: p_transaction_action_id = inv_globals.g_action_logicaldeladj
4983: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4984: )
4985: ) THEN
4986: -- Corrections. Need to retrieve interface_transaction_id and transaction_type
4979: )
4980: )
4981: OR(
4982: p_transaction_action_id = inv_globals.g_action_logicaldeladj
4983: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4984: )
4985: ) THEN
4986: -- Corrections. Need to retrieve interface_transaction_id and transaction_type
4987: BEGIN
5131: END IF;
5132: END IF;
5133:
5134: /***** ISSUE/LotSplit/LotMerge/Cycle,PhysicalCnt/IntransitShipment trx ****/
5135: IF (p_transaction_action_id = inv_globals.g_action_issue)
5136: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5137: AND(l_primary_quantity < 0))
5138: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5139: AND(l_primary_quantity < 0))
5132: END IF;
5133:
5134: /***** ISSUE/LotSplit/LotMerge/Cycle,PhysicalCnt/IntransitShipment trx ****/
5135: IF (p_transaction_action_id = inv_globals.g_action_issue)
5136: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5137: AND(l_primary_quantity < 0))
5138: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5139: AND(l_primary_quantity < 0))
5140: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5134: /***** ISSUE/LotSplit/LotMerge/Cycle,PhysicalCnt/IntransitShipment trx ****/
5135: IF (p_transaction_action_id = inv_globals.g_action_issue)
5136: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5137: AND(l_primary_quantity < 0))
5138: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5139: AND(l_primary_quantity < 0))
5140: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5141: AND(l_primary_quantity < 0))
5142: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5136: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5137: AND(l_primary_quantity < 0))
5138: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5139: AND(l_primary_quantity < 0))
5140: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5141: AND(l_primary_quantity < 0))
5142: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5143: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5144: AND l_primary_quantity < 0)
5138: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5139: AND(l_primary_quantity < 0))
5140: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5141: AND(l_primary_quantity < 0))
5142: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5143: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5144: AND l_primary_quantity < 0)
5145: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5146: AND l_primary_quantity < 0) THEN
5139: AND(l_primary_quantity < 0))
5140: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5141: AND(l_primary_quantity < 0))
5142: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5143: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5144: AND l_primary_quantity < 0)
5145: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5146: AND l_primary_quantity < 0) THEN
5147: IF (l_debug = 1) THEN
5141: AND(l_primary_quantity < 0))
5142: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5143: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5144: AND l_primary_quantity < 0)
5145: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5146: AND l_primary_quantity < 0) THEN
5147: IF (l_debug = 1) THEN
5148: inv_log_util.TRACE(' Action = Issue, lpn=' || p_lpn_id || ',qty=' || l_primary_quantity, 'INV_LPN_TRX_PUB', 9);
5149: END IF;
5156:
5157: v_lpn.lpn_id := p_content_lpn_id;
5158:
5159: IF (
5160: p_transaction_action_id = inv_globals.g_action_intransitshipment
5161: OR(p_transaction_action_id = inv_globals.g_action_issue
5162: AND p_transaction_source_type_id = inv_globals.g_sourcetype_intorder)
5163: ) THEN
5164: IF (p_po_dest_expense = 1 AND p_manual_receipt_expense <> 'Y') THEN
5157: v_lpn.lpn_id := p_content_lpn_id;
5158:
5159: IF (
5160: p_transaction_action_id = inv_globals.g_action_intransitshipment
5161: OR(p_transaction_action_id = inv_globals.g_action_issue
5162: AND p_transaction_source_type_id = inv_globals.g_sourcetype_intorder)
5163: ) THEN
5164: IF (p_po_dest_expense = 1 AND p_manual_receipt_expense <> 'Y') THEN
5165: -- Bug4663000 instead of unpacking expense contents.
5158:
5159: IF (
5160: p_transaction_action_id = inv_globals.g_action_intransitshipment
5161: OR(p_transaction_action_id = inv_globals.g_action_issue
5162: AND p_transaction_source_type_id = inv_globals.g_sourcetype_intorder)
5163: ) THEN
5164: IF (p_po_dest_expense = 1 AND p_manual_receipt_expense <> 'Y') THEN
5165: -- Bug4663000 instead of unpacking expense contents.
5166: -- Change context of LPN to issued out of stores, but only if the
5184: -- For manual rcpt, both Inventory and Expense Internal orders lpns context
5185: -- should be marked as intransit for recieving
5186: v_lpn.lpn_context := wms_container_pub.lpn_context_intransit;
5187: END IF;
5188: ELSIF(p_transaction_action_id = inv_globals.g_action_issue
5189: AND p_transaction_source_type_id = inv_globals.g_sourcetype_wip) THEN
5190: -- For WIP Issues the LPN set to be defined but not used
5191: v_lpn.lpn_context := wms_container_pub.lpn_context_pregenerated;
5192:
5185: -- should be marked as intransit for recieving
5186: v_lpn.lpn_context := wms_container_pub.lpn_context_intransit;
5187: END IF;
5188: ELSIF(p_transaction_action_id = inv_globals.g_action_issue
5189: AND p_transaction_source_type_id = inv_globals.g_sourcetype_wip) THEN
5190: -- For WIP Issues the LPN set to be defined but not used
5191: v_lpn.lpn_context := wms_container_pub.lpn_context_pregenerated;
5192:
5193: IF (l_debug = 1) THEN
5225: END IF;
5226:
5227: -- For an Intransit Shipment, update the LPN with the shipmentNumber
5228: -- so that this LPN can be tracked during the corresponding receipt
5229: IF (p_transaction_action_id = inv_globals.g_action_intransitshipment) THEN
5230: v_lpn.source_name := p_shipment_number;
5231: END IF;
5232:
5233: inv_log_util.TRACE('** 3361969 setting lpn org id to : ' || p_organization_id, 'INV_LPN_TRX_PUB', 9);
5240: IF (l_debug = 1) THEN
5241: inv_log_util.TRACE('*** Issued out LPN :' || p_content_lpn_id, 'INV_LPN_TRX_PUB', 9);
5242: END IF;
5243: ELSIF(
5244: p_transaction_action_id = inv_globals.g_action_issue
5245: AND(
5246: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5247: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5248: )
5242: END IF;
5243: ELSIF(
5244: p_transaction_action_id = inv_globals.g_action_issue
5245: AND(
5246: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5247: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5248: )
5249: ) THEN
5250: -- Return or corrections. Need to retrieve interface_transaction_id and transaction_type
5243: ELSIF(
5244: p_transaction_action_id = inv_globals.g_action_issue
5245: AND(
5246: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5247: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5248: )
5249: ) THEN
5250: -- Return or corrections. Need to retrieve interface_transaction_id and transaction_type
5251: BEGIN
5535: , p_source_trx_id => p_source_transaction_id
5536: );
5537: END IF;
5538: /***** RECEIPT/LotSplit/LotMerge/Cycle/PhysicalCount/IntransitRcpt trx ****/
5539: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)
5540: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5541: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5542: AND(l_primary_quantity > 0))
5543: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5536: );
5537: END IF;
5538: /***** RECEIPT/LotSplit/LotMerge/Cycle/PhysicalCount/IntransitRcpt trx ****/
5539: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)
5540: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5541: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5542: AND(l_primary_quantity > 0))
5543: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5544: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
5537: END IF;
5538: /***** RECEIPT/LotSplit/LotMerge/Cycle/PhysicalCount/IntransitRcpt trx ****/
5539: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)
5540: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5541: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5542: AND(l_primary_quantity > 0))
5543: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5544: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
5545: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
5539: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)
5540: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5541: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5542: AND(l_primary_quantity > 0))
5543: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5544: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
5545: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
5546: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5547: AND l_primary_quantity > 0)
5540: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5541: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5542: AND(l_primary_quantity > 0))
5543: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5544: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
5545: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
5546: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5547: AND l_primary_quantity > 0)
5548: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5541: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5542: AND(l_primary_quantity > 0))
5543: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5544: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
5545: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
5546: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5547: AND l_primary_quantity > 0)
5548: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5549: AND l_primary_quantity > 0)
5542: AND(l_primary_quantity > 0))
5543: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5544: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
5545: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
5546: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5547: AND l_primary_quantity > 0)
5548: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5549: AND l_primary_quantity > 0)
5550: OR(p_transaction_action_id = inv_globals.g_action_logicalreceipt)
5544: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
5545: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
5546: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5547: AND l_primary_quantity > 0)
5548: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5549: AND l_primary_quantity > 0)
5550: OR(p_transaction_action_id = inv_globals.g_action_logicalreceipt)
5551: -- IDS: Logical Transactions for lot serial support
5552: -- IDS: Logical Transactions for lot and serials - Opened up TM to
5546: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5547: AND l_primary_quantity > 0)
5548: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5549: AND l_primary_quantity > 0)
5550: OR(p_transaction_action_id = inv_globals.g_action_logicalreceipt)
5551: -- IDS: Logical Transactions for lot serial support
5552: -- IDS: Logical Transactions for lot and serials - Opened up TM to
5553: -- handle logical receipts and logical corrections.
5554: THEN
5557: END IF;
5558:
5559: -- Check if a receipt with PO or RMA source types check to see if it is a correction
5560: IF (
5561: p_transaction_action_id = inv_globals.g_action_receipt
5562: AND(
5563: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5564: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5565: )
5559: -- Check if a receipt with PO or RMA source types check to see if it is a correction
5560: IF (
5561: p_transaction_action_id = inv_globals.g_action_receipt
5562: AND(
5563: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5564: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5565: )
5566: )
5567: OR(
5560: IF (
5561: p_transaction_action_id = inv_globals.g_action_receipt
5562: AND(
5563: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5564: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5565: )
5566: )
5567: OR(
5568: p_transaction_action_id = inv_globals.g_action_logicalreceipt
5564: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5565: )
5566: )
5567: OR(
5568: p_transaction_action_id = inv_globals.g_action_logicalreceipt
5569: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5570: )
5571: -- IDS:Logical Transaction lot serial support
5572: -- IDS: Logical Transactions for lot and serials - Opened up TM to
5565: )
5566: )
5567: OR(
5568: p_transaction_action_id = inv_globals.g_action_logicalreceipt
5569: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5570: )
5571: -- IDS:Logical Transaction lot serial support
5572: -- IDS: Logical Transactions for lot and serials - Opened up TM to
5573: -- handle logical receipts and logical corrections.
5591: -- otherwise use default behavior
5592: IF (
5593: (
5594: (
5595: p_transaction_action_id = inv_globals.g_action_receipt
5596: AND(
5597: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5598: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5599: )
5593: (
5594: (
5595: p_transaction_action_id = inv_globals.g_action_receipt
5596: AND(
5597: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5598: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5599: )
5600: )
5601: OR(
5594: (
5595: p_transaction_action_id = inv_globals.g_action_receipt
5596: AND(
5597: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5598: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5599: )
5600: )
5601: OR(
5602: p_transaction_action_id = inv_globals.g_action_logicalreceipt
5598: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5599: )
5600: )
5601: OR(
5602: p_transaction_action_id = inv_globals.g_action_logicalreceipt
5603: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5604: )
5605: )
5606: -- IDS: Logical Transactions for lot and serials - Opened up TM to
5599: )
5600: )
5601: OR(
5602: p_transaction_action_id = inv_globals.g_action_logicalreceipt
5603: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5604: )
5605: )
5606: -- IDS: Logical Transactions for lot and serials - Opened up TM to
5607: -- handle logical receipts and logical corrections.
5817: END IF;
5818: END IF;
5819: END IF;
5820: /***** Actions for SUBXFR / ORGXFR / STGXFR transactions ****/
5821: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
5822: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5823: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5824: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5825: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
5818: END IF;
5819: END IF;
5820: /***** Actions for SUBXFR / ORGXFR / STGXFR transactions ****/
5821: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
5822: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5823: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5824: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5825: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
5826: IF (l_debug = 1) THEN
5819: END IF;
5820: /***** Actions for SUBXFR / ORGXFR / STGXFR transactions ****/
5821: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
5822: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5823: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5824: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5825: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
5826: IF (l_debug = 1) THEN
5827: inv_log_util.TRACE(' Action = SubXfr/OrgXfr/StgXfr/CGXfr', 'INV_LPN_TRX_PUB', 9);
5820: /***** Actions for SUBXFR / ORGXFR / STGXFR transactions ****/
5821: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
5822: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5823: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5824: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5825: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
5826: IF (l_debug = 1) THEN
5827: inv_log_util.TRACE(' Action = SubXfr/OrgXfr/StgXfr/CGXfr', 'INV_LPN_TRX_PUB', 9);
5828: END IF;
5821: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
5822: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5823: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5824: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5825: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
5826: IF (l_debug = 1) THEN
5827: inv_log_util.TRACE(' Action = SubXfr/OrgXfr/StgXfr/CGXfr', 'INV_LPN_TRX_PUB', 9);
5828: END IF;
5829:
5828: END IF;
5829:
5830: -- sanity check. If CostGroupXfr, then both cost_group_id and
5831: -- xfr_cost_group_id should be filled
5832: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
5833: IF (p_cost_group_id IS NULL)
5834: OR(p_transfer_cost_group_id IS NULL) THEN
5835: x_proc_msg := 'Error. Cost Groups not specified. CG=' || p_cost_group_id || ',XfrCG=' || p_transfer_cost_group_id;
5836:
5845: END IF;
5846: END IF;
5847:
5848: -- If transaction is subtransfer
5849: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR
5850: p_transaction_action_id = inv_globals.g_action_planxfr )
5851: THEN
5852: IF(p_transfer_lpn_id IS NOT NULL AND p_lpn_id IS NOT NULL) THEN
5853: IF ( v_lpn_ctx IS NULL ) THEN
5846: END IF;
5847:
5848: -- If transaction is subtransfer
5849: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR
5850: p_transaction_action_id = inv_globals.g_action_planxfr )
5851: THEN
5852: IF(p_transfer_lpn_id IS NOT NULL AND p_lpn_id IS NOT NULL) THEN
5853: IF ( v_lpn_ctx IS NULL ) THEN
5854: SELECT lpn_context
5887: -- this LPN, but only if not packing back to the same LPN,
5888: -- unless this is a CostGroup Transfer transaction
5889: IF (p_lpn_id IS NOT NULL)
5890: AND((p_lpn_id <> NVL(p_transfer_lpn_id, 0))
5891: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)) THEN
5892: -- Verify that the context of this LPN is 'Resides in Inventory'
5893: SELECT lpn_context
5894: INTO v_lpn_ctx
5895: FROM wms_license_plate_numbers
5932: , p_source_trx_id => p_source_transaction_id
5933: );
5934:
5935: --bug2747049
5936: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
5937: UPDATE wms_license_plate_numbers
5938: SET lpn_context = v_lpn_ctx
5939: , subinventory_code = p_subinventory_code
5940: , locator_id = p_locator_id
5942: AND lpn_context = wms_container_pub.lpn_context_pregenerated;
5943: END IF;
5944: END IF;
5945:
5946: IF (p_transaction_action_id = inv_globals.g_action_orgxfr) THEN
5947: v_xfr_org := p_transfer_organization;
5948: ELSE
5949: v_xfr_org := p_organization_id;
5950: END IF;
5948: ELSE
5949: v_xfr_org := p_organization_id;
5950: END IF;
5951:
5952: IF (p_transaction_action_id <> inv_globals.g_action_costgroupxfr) THEN
5953: -- Check transfer org to see if it is wms enabled
5954: IF (
5955: wms_install.check_install(x_return_status => ret_status, x_msg_count => ret_msgcnt, x_msg_data => ret_msgdata
5956: , p_organization_id => v_xfr_org)
6001: WHERE lpn_id = p_lpn_id;
6002:
6003: -- For Sub transfers reservations should be transfered
6004: -- for content lpn of who's context is not picked
6005: IF (p_transaction_action_id = inv_globals.g_action_subxfr
6006: AND(l_lpn_ctx_tmp <> wms_container_pub.lpn_context_picked
6007: AND NVL(l_system_task_type, -1) <> 7)) THEN
6008: IF (l_debug = 1) THEN
6009: inv_log_util.TRACE('Sub Xfer of LPN, calling Transfer_LPN_Reservations ', 'INV_LPN_TRX_PUB', 9);
6044:
6045: -- For Sub transfers reservations should be transfered
6046: -- for content lpn of who's context is not picked
6047: IF (
6048: p_transaction_action_id = inv_globals.g_action_subxfr
6049: AND(v_cnt_lpn_ctx <> wms_container_pub.lpn_context_picked
6050: AND NVL(l_system_task_type, -1) <> 7)
6051: ) -- bug 2879208 added nv for 3240617
6052: THEN
6056:
6057: /*Added for Bug#6043776*/
6058: l_cyclpn_id:=p_content_lpn_id;
6059: /*if the transaction is cyclecount use outer LPN to update reservations*/
6060: IF(p_transaction_source_type_id=inv_globals.G_SOURCETYPE_CYCLECOUNT) THEN
6061: IF (l_debug = 1) THEN
6062: inv_log_util.TRACE('entered here cyclecount.. Bug#6043776','INV_LPN_TRX_PUB', 9);
6063: END IF;
6064: SELECT OUTERMOST_LPN_ID into l_cyclpn_id
6148: ELSE
6149: --Bug 5509764
6150: --For direct org transfer against an internal req, set the lpn_context
6151: --to "In Inventory" from Picked to reflect the correct status
6152: IF ( p_transaction_source_type_id = inv_globals.G_SOURCETYPE_INTORDER AND
6153: p_transaction_action_id = inv_globals.G_ACTION_ORGXFR) THEN
6154: IF (l_debug = 1) THEN
6155: inv_log_util.trace('int req direct org xfr. setting lpn_ctxt to in inventory','INV_LPN_TRX_PUB',1);
6156: END IF;
6149: --Bug 5509764
6150: --For direct org transfer against an internal req, set the lpn_context
6151: --to "In Inventory" from Picked to reflect the correct status
6152: IF ( p_transaction_source_type_id = inv_globals.G_SOURCETYPE_INTORDER AND
6153: p_transaction_action_id = inv_globals.G_ACTION_ORGXFR) THEN
6154: IF (l_debug = 1) THEN
6155: inv_log_util.trace('int req direct org xfr. setting lpn_ctxt to in inventory','INV_LPN_TRX_PUB',1);
6156: END IF;
6157: v_lpn.lpn_context := wms_container_pub.lpn_context_inv;
6165: END IF;
6166:
6167: -- Bug 4247497 Moving update of context to TM. If this is a stagexfr transaction
6168: -- then lpn-context should be updated to 'picked'
6169: IF ( p_transaction_action_id = inv_globals.G_ACTION_STGXFR ) THEN
6170: v_lpn.lpn_context := wms_container_pub.LPN_CONTEXT_PICKED;
6171: END IF;
6172:
6173: /** moved update here to fix bug3299521, this way we would avoid updating
6179: -- this LPN, but only if not unpacked from the same LPN,
6180: -- unless this is a CostGroup Transfer transaction
6181: IF (p_transfer_lpn_id IS NOT NULL)
6182: AND((NVL(p_lpn_id, 0) <> p_transfer_lpn_id)
6183: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)) THEN
6184: SELECT lpn_context
6185: INTO v_xfrlpn_ctx
6186: FROM wms_license_plate_numbers
6187: WHERE lpn_id = p_transfer_lpn_id;
6213: , 9);
6214: END IF;
6215: ELSE
6216: -- Bug 4247497 Moving update of context to TM
6217: IF ( p_transaction_action_id = inv_globals.g_action_stgxfr ) THEN
6218: v_lpn.lpn_context := wms_container_pub.lpn_context_picked;
6219: ELSE
6220: v_lpn.lpn_context := wms_container_pub.lpn_context_inv;
6221: END IF;
6246:
6247: -- For CostGroupTransfer transactions, use the xfr_cost_group_id
6248: -- column from MMTT. For all other transactions, use the cost_group_id
6249: -- For CostGrpTrx, sub and location are same as that of source side.
6250: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
6251: l_xfr_sub := p_subinventory_code;
6252: l_xfr_loc := p_locator_id;
6253: ELSE
6254: l_xfr_sub := p_transfer_subinventory;
6328: END IF;
6329:
6330: -- For cases of bulk picking the lpn_id and xfr_lpn_id will be same
6331: -- need to change the sub and locator information to the xfer location
6332: IF (p_transaction_action_id = inv_globals.g_action_stgxfr
6333: AND p_lpn_id = p_transfer_lpn_id) THEN
6334: SELECT lpn_context
6335: INTO v_xfrlpn_ctx
6336: FROM wms_license_plate_numbers
6342: END IF;
6343:
6344: -- If the lpn is transfered update the status of that LPN
6345: -- provided the context is 2, 3, or 8
6346: IF (p_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder)
6347: AND(
6348: (v_xfrlpn_ctx = wms_container_pub.lpn_context_wip)
6349: OR(v_xfrlpn_ctx = wms_container_pub.lpn_context_rcv)
6350: OR(v_xfrlpn_ctx = wms_container_pub.lpn_context_packing)
6387: update_lpn_status(v_lpn);
6388: END IF;
6389:
6390: -- If transaction is subtransfer
6391: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR
6392: p_transaction_action_id = inv_globals.g_action_planxfr )
6393: THEN
6394: IF (p_content_lpn_id IS NOT NULL) THEN
6395: SELECT lpn_context
6388: END IF;
6389:
6390: -- If transaction is subtransfer
6391: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR
6392: p_transaction_action_id = inv_globals.g_action_planxfr )
6393: THEN
6394: IF (p_content_lpn_id IS NOT NULL) THEN
6395: SELECT lpn_context
6396: INTO v_cnt_lpn_ctx
6430: END IF;
6431: END IF;
6432: END IF;
6433: /***** Actions for PACK transactions ****/
6434: ELSIF(p_transaction_action_id = inv_globals.g_action_containerpack) THEN
6435: IF (l_debug = 1) THEN
6436: inv_log_util.TRACE(' Action = Pack', 'INV_LPN_TRX_PUB', 9);
6437: END IF;
6438:
6467: SET lpn_context = wms_container_pub.lpn_context_inv
6468: WHERE lpn_id = p_transfer_lpn_id
6469: AND lpn_context <> wms_container_pub.lpn_context_picked;
6470: /***** Actions for UNPACK transactions ****/
6471: ELSIF(p_transaction_action_id = inv_globals.g_action_containerunpack) THEN
6472: IF (l_debug = 1) THEN
6473: inv_log_util.TRACE(' Action = UnPack', 'INV_LPN_TRX_PUB', 9);
6474: END IF;
6475:
6497: );
6498: -- If LPN is item-tracked, then need to change container status. TODO
6499:
6500: /***** Actions for SLPIT transactions ****/
6501: ELSIF(p_transaction_action_id = inv_globals.g_action_containersplit) THEN
6502: IF (l_debug = 1) THEN
6503: inv_log_util.TRACE(' Action = Split, First Unpack', 'INV_LPN_TRX_PUB', 9);
6504: END IF;
6505:
6604: -- If Sales Order Issue or Int.Order Issue/SubXfr/Intransit Shipment
6605: -- need to popluate the content_lpn in MMTT with the outermost lpn
6606: -- for shipping
6607: /*if p_content_lpn_id is not NULL AND
6608: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND
6609: p_transaction_action_id = inv_globals.G_Action_Issue) OR
6610: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
6611: (p_transaction_action_id = inv_globals.G_Action_Issue OR
6612: p_transaction_action_id =
6605: -- need to popluate the content_lpn in MMTT with the outermost lpn
6606: -- for shipping
6607: /*if p_content_lpn_id is not NULL AND
6608: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND
6609: p_transaction_action_id = inv_globals.G_Action_Issue) OR
6610: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
6611: (p_transaction_action_id = inv_globals.G_Action_Issue OR
6612: p_transaction_action_id =
6613: inv_globals.G_Action_Subxfr OR
6606: -- for shipping
6607: /*if p_content_lpn_id is not NULL AND
6608: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND
6609: p_transaction_action_id = inv_globals.G_Action_Issue) OR
6610: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
6611: (p_transaction_action_id = inv_globals.G_Action_Issue OR
6612: p_transaction_action_id =
6613: inv_globals.G_Action_Subxfr OR
6614: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
6607: /*if p_content_lpn_id is not NULL AND
6608: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND
6609: p_transaction_action_id = inv_globals.G_Action_Issue) OR
6610: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
6611: (p_transaction_action_id = inv_globals.G_Action_Issue OR
6612: p_transaction_action_id =
6613: inv_globals.G_Action_Subxfr OR
6614: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
6615: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
6609: p_transaction_action_id = inv_globals.G_Action_Issue) OR
6610: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
6611: (p_transaction_action_id = inv_globals.G_Action_Issue OR
6612: p_transaction_action_id =
6613: inv_globals.G_Action_Subxfr OR
6614: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
6615: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
6616: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
6617: BEGIN
6610: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
6611: (p_transaction_action_id = inv_globals.G_Action_Issue OR
6612: p_transaction_action_id =
6613: inv_globals.G_Action_Subxfr OR
6614: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
6615: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
6616: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
6617: BEGIN
6618: UPDATE mtl_material_transactions_temp
6611: (p_transaction_action_id = inv_globals.G_Action_Issue OR
6612: p_transaction_action_id =
6613: inv_globals.G_Action_Subxfr OR
6614: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
6615: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
6616: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
6617: BEGIN
6618: UPDATE mtl_material_transactions_temp
6619: SET content_lpn_id = (SELECT outermost_lpn_id
6612: p_transaction_action_id =
6613: inv_globals.G_Action_Subxfr OR
6614: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
6615: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
6616: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
6617: BEGIN
6618: UPDATE mtl_material_transactions_temp
6619: SET content_lpn_id = (SELECT outermost_lpn_id
6620: FROM wms_license_plate_numbers