eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_COMINGLING_UTILS dependencies on INV_GLOBALS

Line 64: ** Issue from stores 1 inv_globals.G_Action_Issue

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

Line 65: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr

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

Line 66: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr

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

Line 67: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment

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

Line 68: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr

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: **

Line 69: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj

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:

Line 70: ** Assembly Return 32 inv_globals.G_Action_AssyReturn

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

Line 71: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn

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: ** --------------------------------------------------------------------------

Line 221: AND transaction_action_id not in (inv_globals.G_Action_Issue,

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,

Line 222: inv_globals.G_Action_Subxfr,

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,

Line 223: inv_globals.G_Action_Orgxfr,

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,

Line 224: inv_globals.G_Action_IntransitShipment,

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)

Line 225: inv_globals.G_Action_Stgxfr,

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');

Line 226: inv_globals.G_Action_DeliveryAdj,

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

Line 227: inv_globals.G_Action_AssyReturn,

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

Line 228: inv_globals.G_Action_NegCompReturn)

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';

Line 262: AND transaction_action_id not in (inv_globals.G_Action_Issue,

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,

Line 263: inv_globals.G_Action_Subxfr,

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,

Line 264: inv_globals.G_Action_Orgxfr,

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,

Line 265: inv_globals.G_Action_IntransitShipment,

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)

Line 266: inv_globals.G_Action_Stgxfr,

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');

Line 267: inv_globals.G_Action_DeliveryAdj,

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

Line 268: inv_globals.G_Action_AssyReturn,

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

Line 269: inv_globals.G_Action_NegCompReturn)

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';

Line 309: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, organization_id)= p_organization_id

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

Line 318: AND transaction_action_id in (inv_globals.G_Action_Subxfr,

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

Line 319: inv_globals.G_Action_Orgxfr,

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

Line 320: inv_globals.G_Action_Stgxfr)

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';

Line 339: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, organization_id)= p_organization_id

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

Line 348: AND transaction_action_id in (inv_globals.G_Action_Subxfr,

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

Line 349: inv_globals.G_Action_Orgxfr,

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

Line 350: inv_globals.G_Action_Stgxfr)

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';

Line 374: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, mmtt.organization_id)= p_organization_id

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

Line 384: AND transaction_action_id in (inv_globals.G_Action_Subxfr,

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

Line 385: inv_globals.G_Action_Orgxfr,

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

Line 386: inv_globals.G_Action_Stgxfr)

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';

Line 406: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, mmtt.organization_id)= p_organization_id

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

Line 416: AND transaction_action_id in (inv_globals.G_Action_Subxfr,

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

Line 417: inv_globals.G_Action_Orgxfr,

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

Line 418: inv_globals.G_Action_Stgxfr)

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';

Line 721: if (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_SUBXFR)

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:

Line 722: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_PLANXFR)

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;

Line 723: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_ORGXFR)

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;

Line 724: OR (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR) then

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;

Line 729: if (p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_ORGXFR) 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;
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;

Line 795: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_ACTION_ISSUE)

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)

Line 796: AND (p_mmtt_rec.transaction_action_id <> inv_globals.g_action_inv_lot_translate)

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)

Line 797: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_CostGroupXfr)

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) ))

Line 798: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_IntransitShipment)

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)

Line 799: AND (p_mmtt_rec.transaction_action_id <> inv_globals.G_Action_inv_lot_split)

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) ))

Line 800: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_CycleCountAdj)

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)

Line 802: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_Action_PhysicalCountAdj)

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))

Line 804: AND (NOT ((p_mmtt_rec.transaction_action_id = inv_globals.G_ACTION_STGXFR)

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:

Line 818: ** (inv_globals.G_ACTION_SUBXFR,

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:

Line 819: ** inv_globals.G_ACTION_ORGXFR,

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

Line 820: ** inv_globals.G_ACTION_STGXFR)

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;