60: **
61: **
62: ** transaction actions
63: **
64: ** Issue from stores 1 inv_globals.G_Action_Issue
65: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
66: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
61: **
62: ** transaction actions
63: **
64: ** Issue from stores 1 inv_globals.G_Action_Issue
65: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
66: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
69: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
62: ** transaction actions
63: **
64: ** Issue from stores 1 inv_globals.G_Action_Issue
65: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
66: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
69: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
70: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
63: **
64: ** Issue from stores 1 inv_globals.G_Action_Issue
65: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
66: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
69: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
70: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
71: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
64: ** Issue from stores 1 inv_globals.G_Action_Issue
65: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
66: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
69: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
70: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
71: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
72: **
65: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
66: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
69: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
70: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
71: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
72: **
73: ** Returns:
66: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
69: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
70: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
71: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
72: **
73: ** Returns:
74: ** none
67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
69: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
70: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
71: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
72: **
73: ** Returns:
74: ** none
75: ** --------------------------------------------------------------------------
217: AND (locator_id = p_locator_id
218: OR locator_id is null and p_locator_id is null)
219: AND cost_group_id is not null
220: AND cost_group_id <> p_cost_group_id
221: AND transaction_action_id not in (inv_globals.G_Action_Issue,
222: inv_globals.G_Action_Subxfr,
223: inv_globals.G_Action_Orgxfr,
224: inv_globals.G_Action_IntransitShipment,
225: inv_globals.G_Action_Stgxfr,
218: OR locator_id is null and p_locator_id is null)
219: AND cost_group_id is not null
220: AND cost_group_id <> p_cost_group_id
221: AND transaction_action_id not in (inv_globals.G_Action_Issue,
222: inv_globals.G_Action_Subxfr,
223: inv_globals.G_Action_Orgxfr,
224: inv_globals.G_Action_IntransitShipment,
225: inv_globals.G_Action_Stgxfr,
226: inv_globals.G_Action_DeliveryAdj,
219: AND cost_group_id is not null
220: AND cost_group_id <> p_cost_group_id
221: AND transaction_action_id not in (inv_globals.G_Action_Issue,
222: inv_globals.G_Action_Subxfr,
223: inv_globals.G_Action_Orgxfr,
224: inv_globals.G_Action_IntransitShipment,
225: inv_globals.G_Action_Stgxfr,
226: inv_globals.G_Action_DeliveryAdj,
227: inv_globals.G_Action_AssyReturn,
220: AND cost_group_id <> p_cost_group_id
221: AND transaction_action_id not in (inv_globals.G_Action_Issue,
222: inv_globals.G_Action_Subxfr,
223: inv_globals.G_Action_Orgxfr,
224: inv_globals.G_Action_IntransitShipment,
225: inv_globals.G_Action_Stgxfr,
226: inv_globals.G_Action_DeliveryAdj,
227: inv_globals.G_Action_AssyReturn,
228: inv_globals.G_Action_NegCompReturn)
221: AND transaction_action_id not in (inv_globals.G_Action_Issue,
222: inv_globals.G_Action_Subxfr,
223: inv_globals.G_Action_Orgxfr,
224: inv_globals.G_Action_IntransitShipment,
225: inv_globals.G_Action_Stgxfr,
226: inv_globals.G_Action_DeliveryAdj,
227: inv_globals.G_Action_AssyReturn,
228: inv_globals.G_Action_NegCompReturn)
229: AND posting_flag = 'Y');
222: inv_globals.G_Action_Subxfr,
223: inv_globals.G_Action_Orgxfr,
224: inv_globals.G_Action_IntransitShipment,
225: inv_globals.G_Action_Stgxfr,
226: inv_globals.G_Action_DeliveryAdj,
227: inv_globals.G_Action_AssyReturn,
228: inv_globals.G_Action_NegCompReturn)
229: AND posting_flag = 'Y');
230: EXCEPTION
223: inv_globals.G_Action_Orgxfr,
224: inv_globals.G_Action_IntransitShipment,
225: inv_globals.G_Action_Stgxfr,
226: inv_globals.G_Action_DeliveryAdj,
227: inv_globals.G_Action_AssyReturn,
228: inv_globals.G_Action_NegCompReturn)
229: AND posting_flag = 'Y');
230: EXCEPTION
231: WHEN no_data_found THEN
224: inv_globals.G_Action_IntransitShipment,
225: inv_globals.G_Action_Stgxfr,
226: inv_globals.G_Action_DeliveryAdj,
227: inv_globals.G_Action_AssyReturn,
228: inv_globals.G_Action_NegCompReturn)
229: AND posting_flag = 'Y');
230: EXCEPTION
231: WHEN no_data_found THEN
232: l_mmtt_receipts_exist := 'N';
258: AND (mmtt.locator_id = p_locator_id
259: OR mmtt.locator_id is null and p_locator_id is null)
260: AND mmtt.cost_group_id is not null
261: AND mmtt.cost_group_id <> p_cost_group_id
262: AND transaction_action_id not in (inv_globals.G_Action_Issue,
263: inv_globals.G_Action_Subxfr,
264: inv_globals.G_Action_Orgxfr,
265: inv_globals.G_Action_IntransitShipment,
266: inv_globals.G_Action_Stgxfr,
259: OR mmtt.locator_id is null and p_locator_id is null)
260: AND mmtt.cost_group_id is not null
261: AND mmtt.cost_group_id <> p_cost_group_id
262: AND transaction_action_id not in (inv_globals.G_Action_Issue,
263: inv_globals.G_Action_Subxfr,
264: inv_globals.G_Action_Orgxfr,
265: inv_globals.G_Action_IntransitShipment,
266: inv_globals.G_Action_Stgxfr,
267: inv_globals.G_Action_DeliveryAdj,
260: AND mmtt.cost_group_id is not null
261: AND mmtt.cost_group_id <> p_cost_group_id
262: AND transaction_action_id not in (inv_globals.G_Action_Issue,
263: inv_globals.G_Action_Subxfr,
264: inv_globals.G_Action_Orgxfr,
265: inv_globals.G_Action_IntransitShipment,
266: inv_globals.G_Action_Stgxfr,
267: inv_globals.G_Action_DeliveryAdj,
268: inv_globals.G_Action_AssyReturn,
261: AND mmtt.cost_group_id <> p_cost_group_id
262: AND transaction_action_id not in (inv_globals.G_Action_Issue,
263: inv_globals.G_Action_Subxfr,
264: inv_globals.G_Action_Orgxfr,
265: inv_globals.G_Action_IntransitShipment,
266: inv_globals.G_Action_Stgxfr,
267: inv_globals.G_Action_DeliveryAdj,
268: inv_globals.G_Action_AssyReturn,
269: inv_globals.G_Action_NegCompReturn)
262: AND transaction_action_id not in (inv_globals.G_Action_Issue,
263: inv_globals.G_Action_Subxfr,
264: inv_globals.G_Action_Orgxfr,
265: inv_globals.G_Action_IntransitShipment,
266: inv_globals.G_Action_Stgxfr,
267: inv_globals.G_Action_DeliveryAdj,
268: inv_globals.G_Action_AssyReturn,
269: inv_globals.G_Action_NegCompReturn)
270: AND mmtt.posting_flag = 'Y');
263: inv_globals.G_Action_Subxfr,
264: inv_globals.G_Action_Orgxfr,
265: inv_globals.G_Action_IntransitShipment,
266: inv_globals.G_Action_Stgxfr,
267: inv_globals.G_Action_DeliveryAdj,
268: inv_globals.G_Action_AssyReturn,
269: inv_globals.G_Action_NegCompReturn)
270: AND mmtt.posting_flag = 'Y');
271: EXCEPTION
264: inv_globals.G_Action_Orgxfr,
265: inv_globals.G_Action_IntransitShipment,
266: inv_globals.G_Action_Stgxfr,
267: inv_globals.G_Action_DeliveryAdj,
268: inv_globals.G_Action_AssyReturn,
269: inv_globals.G_Action_NegCompReturn)
270: AND mmtt.posting_flag = 'Y');
271: EXCEPTION
272: WHEN no_data_found THEN
265: inv_globals.G_Action_IntransitShipment,
266: inv_globals.G_Action_Stgxfr,
267: inv_globals.G_Action_DeliveryAdj,
268: inv_globals.G_Action_AssyReturn,
269: inv_globals.G_Action_NegCompReturn)
270: AND mmtt.posting_flag = 'Y');
271: EXCEPTION
272: WHEN no_data_found THEN
273: l_mmtt_receipts_exist := 'N';
305: --select
306: --count(*)
307: --into l_mmtt_transfers_count
308: from mtl_material_transactions_temp
309: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, organization_id)= p_organization_id
310: and inventory_item_id = p_inventory_item_id
311: and (revision = p_revision
312: OR revision is null and p_revision is null)
313: AND lot_number is null
314: AND transfer_subinventory = p_subinventory_code
315: AND transfer_to_location IS null
316: AND transfer_cost_group_id is not null
317: AND transfer_cost_group_id <> p_cost_group_id
318: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
319: inv_globals.G_Action_Orgxfr,
320: inv_globals.G_Action_Stgxfr)
321: AND posting_flag = 'Y');
322: EXCEPTION
315: AND transfer_to_location IS null
316: AND transfer_cost_group_id is not null
317: AND transfer_cost_group_id <> p_cost_group_id
318: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
319: inv_globals.G_Action_Orgxfr,
320: inv_globals.G_Action_Stgxfr)
321: AND posting_flag = 'Y');
322: EXCEPTION
323: WHEN no_data_found THEN
316: AND transfer_cost_group_id is not null
317: AND transfer_cost_group_id <> p_cost_group_id
318: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
319: inv_globals.G_Action_Orgxfr,
320: inv_globals.G_Action_Stgxfr)
321: AND posting_flag = 'Y');
322: EXCEPTION
323: WHEN no_data_found THEN
324: l_mmtt_transfers_exist := 'N';
335: --select
336: --count(*)
337: --into l_mmtt_transfers_count
338: from mtl_material_transactions_temp
339: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, organization_id)= p_organization_id
340: and inventory_item_id = p_inventory_item_id
341: and (revision = p_revision
342: OR revision is null and p_revision is null)
343: AND lot_number is null
344: AND transfer_subinventory = p_subinventory_code
345: AND transfer_to_location = p_locator_id
346: AND transfer_cost_group_id is not null
347: AND transfer_cost_group_id <> p_cost_group_id
348: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
349: inv_globals.G_Action_Orgxfr,
350: inv_globals.G_Action_Stgxfr)
351: AND posting_flag = 'Y');
352: EXCEPTION
345: AND transfer_to_location = p_locator_id
346: AND transfer_cost_group_id is not null
347: AND transfer_cost_group_id <> p_cost_group_id
348: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
349: inv_globals.G_Action_Orgxfr,
350: inv_globals.G_Action_Stgxfr)
351: AND posting_flag = 'Y');
352: EXCEPTION
353: WHEN no_data_found THEN
346: AND transfer_cost_group_id is not null
347: AND transfer_cost_group_id <> p_cost_group_id
348: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
349: inv_globals.G_Action_Orgxfr,
350: inv_globals.G_Action_Stgxfr)
351: AND posting_flag = 'Y');
352: EXCEPTION
353: WHEN no_data_found THEN
354: l_mmtt_transfers_exist := 'N';
370: --count(*)
371: --into l_mmtt_transfers_count
372: from mtl_material_transactions_temp mmtt,
373: mtl_transaction_lots_temp mtlt
374: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, mmtt.organization_id)= p_organization_id
375: AND mmtt.inventory_item_id = p_inventory_item_id
376: AND (mmtt.revision = p_revision
377: OR mmtt.revision is null and p_revision is null)
378: AND (mtlt.lot_number = p_lot_number
380: AND mmtt.transfer_subinventory = p_subinventory_code
381: AND mmtt.transfer_to_location IS null
382: AND mmtt.transfer_cost_group_id is not null
383: AND mmtt.transfer_cost_group_id <> p_cost_group_id
384: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
385: inv_globals.G_Action_Orgxfr,
386: inv_globals.G_Action_Stgxfr)
387: AND posting_flag = 'Y');
388: EXCEPTION
381: AND mmtt.transfer_to_location IS null
382: AND mmtt.transfer_cost_group_id is not null
383: AND mmtt.transfer_cost_group_id <> p_cost_group_id
384: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
385: inv_globals.G_Action_Orgxfr,
386: inv_globals.G_Action_Stgxfr)
387: AND posting_flag = 'Y');
388: EXCEPTION
389: WHEN no_data_found THEN
382: AND mmtt.transfer_cost_group_id is not null
383: AND mmtt.transfer_cost_group_id <> p_cost_group_id
384: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
385: inv_globals.G_Action_Orgxfr,
386: inv_globals.G_Action_Stgxfr)
387: AND posting_flag = 'Y');
388: EXCEPTION
389: WHEN no_data_found THEN
390: l_mmtt_transfers_exist := 'N';
402: --count(*)
403: --into l_mmtt_transfers_count
404: from mtl_material_transactions_temp mmtt,
405: mtl_transaction_lots_temp mtlt
406: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, mmtt.organization_id)= p_organization_id
407: AND mmtt.inventory_item_id = p_inventory_item_id
408: AND (mmtt.revision = p_revision
409: OR mmtt.revision is null and p_revision is null)
410: AND (mtlt.lot_number = p_lot_number
412: AND mmtt.transfer_subinventory = p_subinventory_code
413: AND mmtt.transfer_to_location = p_locator_id
414: AND mmtt.transfer_cost_group_id is not null
415: AND mmtt.transfer_cost_group_id <> p_cost_group_id
416: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
417: inv_globals.G_Action_Orgxfr,
418: inv_globals.G_Action_Stgxfr)
419: AND posting_flag = 'Y');
420: EXCEPTION
413: AND mmtt.transfer_to_location = p_locator_id
414: AND mmtt.transfer_cost_group_id is not null
415: AND mmtt.transfer_cost_group_id <> p_cost_group_id
416: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
417: inv_globals.G_Action_Orgxfr,
418: inv_globals.G_Action_Stgxfr)
419: AND posting_flag = 'Y');
420: EXCEPTION
421: WHEN no_data_found THEN
414: AND mmtt.transfer_cost_group_id is not null
415: AND mmtt.transfer_cost_group_id <> p_cost_group_id
416: AND transaction_action_id in (inv_globals.G_Action_Subxfr,
417: inv_globals.G_Action_Orgxfr,
418: inv_globals.G_Action_Stgxfr)
419: AND posting_flag = 'Y');
420: EXCEPTION
421: WHEN no_data_found THEN
422: l_mmtt_transfers_exist := 'N';
717: l_comingle_loc := p_mmtt_rec.locator_id;
718: l_comingle_cg := p_mmtt_rec.cost_group_id;
719: -- For transfer transactions, pass the attributes of the transfer(receipt)
720: -- side to comingle check.
721: if (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_SUBXFR)
722: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_PLANXFR)
723: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_ORGXFR)
724: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR) then
725:
718: l_comingle_cg := p_mmtt_rec.cost_group_id;
719: -- For transfer transactions, pass the attributes of the transfer(receipt)
720: -- side to comingle check.
721: if (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_SUBXFR)
722: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_PLANXFR)
723: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_ORGXFR)
724: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR) then
725:
726: l_comingle_sub := p_mmtt_rec.transfer_subinventory;
719: -- For transfer transactions, pass the attributes of the transfer(receipt)
720: -- side to comingle check.
721: if (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_SUBXFR)
722: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_PLANXFR)
723: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_ORGXFR)
724: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR) then
725:
726: l_comingle_sub := p_mmtt_rec.transfer_subinventory;
727: l_comingle_loc := p_mmtt_rec.transfer_to_location;
720: -- side to comingle check.
721: if (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_SUBXFR)
722: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_PLANXFR)
723: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_ORGXFR)
724: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR) then
725:
726: l_comingle_sub := p_mmtt_rec.transfer_subinventory;
727: l_comingle_loc := p_mmtt_rec.transfer_to_location;
728: l_comingle_cg := p_mmtt_rec.transfer_cost_group_id;
725:
726: l_comingle_sub := p_mmtt_rec.transfer_subinventory;
727: l_comingle_loc := p_mmtt_rec.transfer_to_location;
728: l_comingle_cg := p_mmtt_rec.transfer_cost_group_id;
729: if (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_ORGXFR) then
730: l_comingle_org := Nvl(p_mmtt_rec.transfer_organization,p_mmtt_rec.organization_id);
731: end if;
732:
733: end if;
791: -- and transfer-cost-group is null. This is the case where the CostGroupAPI
792: -- does not populate cost-group as CostGroup is derived by INV_WWACST.
793: if (l_content_lpn_id is NULL)
794: AND (l_wms_org_flag)
795: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_ACTION_ISSUE)
796: AND (p_mmtt_rec.transaction_action_id <> inv_globals.g_action_inv_lot_translate)
797: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_CostGroupXfr)
798: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_IntransitShipment)
799: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_inv_lot_split)
792: -- does not populate cost-group as CostGroup is derived by INV_WWACST.
793: if (l_content_lpn_id is NULL)
794: AND (l_wms_org_flag)
795: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_ACTION_ISSUE)
796: AND (p_mmtt_rec.transaction_action_id <> inv_globals.g_action_inv_lot_translate)
797: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_CostGroupXfr)
798: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_IntransitShipment)
799: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_inv_lot_split)
800: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_CycleCountAdj)
793: if (l_content_lpn_id is NULL)
794: AND (l_wms_org_flag)
795: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_ACTION_ISSUE)
796: AND (p_mmtt_rec.transaction_action_id <> inv_globals.g_action_inv_lot_translate)
797: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_CostGroupXfr)
798: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_IntransitShipment)
799: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_inv_lot_split)
800: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_CycleCountAdj)
801: AND (p_mmtt_rec.primary_quantity < 0) ))
794: AND (l_wms_org_flag)
795: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_ACTION_ISSUE)
796: AND (p_mmtt_rec.transaction_action_id <> inv_globals.g_action_inv_lot_translate)
797: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_CostGroupXfr)
798: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_IntransitShipment)
799: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_inv_lot_split)
800: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_CycleCountAdj)
801: AND (p_mmtt_rec.primary_quantity < 0) ))
802: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_PhysicalCountAdj)
795: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_ACTION_ISSUE)
796: AND (p_mmtt_rec.transaction_action_id <> inv_globals.g_action_inv_lot_translate)
797: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_CostGroupXfr)
798: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_IntransitShipment)
799: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_inv_lot_split)
800: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_CycleCountAdj)
801: AND (p_mmtt_rec.primary_quantity < 0) ))
802: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_PhysicalCountAdj)
803: AND (p_mmtt_rec.primary_quantity < 0) ))
796: AND (p_mmtt_rec.transaction_action_id <> inv_globals.g_action_inv_lot_translate)
797: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_CostGroupXfr)
798: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_IntransitShipment)
799: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_inv_lot_split)
800: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_CycleCountAdj)
801: AND (p_mmtt_rec.primary_quantity < 0) ))
802: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_PhysicalCountAdj)
803: AND (p_mmtt_rec.primary_quantity < 0) ))
804: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR)
798: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_IntransitShipment)
799: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_inv_lot_split)
800: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_CycleCountAdj)
801: AND (p_mmtt_rec.primary_quantity < 0) ))
802: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_PhysicalCountAdj)
803: AND (p_mmtt_rec.primary_quantity < 0) ))
804: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR)
805: AND (l_transfer_lpn_id is not NULL)))
806: AND ( nvl(l_lpn_id, 1) <> nvl(l_transfer_lpn_id, 2))
800: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_CycleCountAdj)
801: AND (p_mmtt_rec.primary_quantity < 0) ))
802: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_PhysicalCountAdj)
803: AND (p_mmtt_rec.primary_quantity < 0) ))
804: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR)
805: AND (l_transfer_lpn_id is not NULL)))
806: AND ( nvl(l_lpn_id, 1) <> nvl(l_transfer_lpn_id, 2))
807: AND l_comingle_cg IS NOT NULL then
808:
814: **check
815: **((p_mmtt_rec.cost_group_id is not NULL)
816: ** OR
817: ** (p_mmtt_rec.transaction_action_id in
818: ** (inv_globals.G_ACTION_SUBXFR,
819: ** inv_globals.G_ACTION_ORGXFR,
820: ** inv_globals.G_ACTION_STGXFR)
821: ** AND p_mmtt_rec.transfer_cost_group_id is not NULL) ) THEN ***/
822:
815: **((p_mmtt_rec.cost_group_id is not NULL)
816: ** OR
817: ** (p_mmtt_rec.transaction_action_id in
818: ** (inv_globals.G_ACTION_SUBXFR,
819: ** inv_globals.G_ACTION_ORGXFR,
820: ** inv_globals.G_ACTION_STGXFR)
821: ** AND p_mmtt_rec.transfer_cost_group_id is not NULL) ) THEN ***/
822:
823: l_check_done := FALSE; --4576727
816: ** OR
817: ** (p_mmtt_rec.transaction_action_id in
818: ** (inv_globals.G_ACTION_SUBXFR,
819: ** inv_globals.G_ACTION_ORGXFR,
820: ** inv_globals.G_ACTION_STGXFR)
821: ** AND p_mmtt_rec.transfer_cost_group_id is not NULL) ) THEN ***/
822:
823: l_check_done := FALSE; --4576727
824: OPEN mtlt_cur;