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_CR_ASN_DETAILS dependencies on WMS_ASN_DETAILS

Line 33: insert into WMS_ASN_DETAILS (

29: BEGIN
30: l_userid := fnd_global.user_id;
31: l_loginid := fnd_global.login_id;
32:
33: insert into WMS_ASN_DETAILS (
34: GROUP_ID ,
35: SHIPMENT_NUM ,
36: ORGANIZATION_ID ,
37: DISCREPANCY_REPORTING_CONTEXT ,

Line 106: from WMS_ASN_DETAILS

102: l_loginid := fnd_global.login_id;
103:
104: Begin
105: select 1 into l_exists
106: from WMS_ASN_DETAILS
107: where shipment_num = p_create_asn_details_rec.SHIPMENT_NUM
108: and organization_id = p_create_asn_details_rec.ORGANIZATION_ID
109: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
110: and ITEM_ID = p_create_asn_details_rec.ITEM_ID

Line 113: update WMS_ASN_DETAILS set quantity_actual = (nvl(quantity_actual,0) + p_create_asn_details_rec.QUANTITY_ACTUAL) ,

109: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
110: and ITEM_ID = p_create_asn_details_rec.ITEM_ID
111: ;
112:
113: update WMS_ASN_DETAILS set quantity_actual = (nvl(quantity_actual,0) + p_create_asn_details_rec.QUANTITY_ACTUAL) ,
114: unit_of_measure_actual = p_create_asn_details_rec.unit_of_measure_actual,
115: item_revision_actual = p_create_asn_details_rec.item_revision_actual,
116: transaction_date = sysdate,
117: last_update_date = sysdate,

Line 148: from WMS_ASN_DETAILS

144: l_loginid := fnd_global.login_id;
145:
146: Begin
147: select 1 into l_exists
148: from WMS_ASN_DETAILS
149: where shipment_num = p_create_asn_details_rec.SHIPMENT_NUM
150: and organization_id = p_create_asn_details_rec.ORGANIZATION_ID
151: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
152: and ITEM_ID = p_create_asn_details_rec.ITEM_ID

Line 155: update WMS_ASN_DETAILS set quantity_expected = ( quantity_expected + p_create_asn_details_rec.QUANTITY_EXPECTED) ,

151: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
152: and ITEM_ID = p_create_asn_details_rec.ITEM_ID
153: ;
154:
155: update WMS_ASN_DETAILS set quantity_expected = ( quantity_expected + p_create_asn_details_rec.QUANTITY_EXPECTED) ,
156: transaction_date = sysdate,
157: last_update_date = sysdate,
158: last_updated_by = l_userid,
159: last_update_login = l_loginid

Line 212: from WMS_ASN_DETAILS

208: BEGIN
209:
210: Begin
211: select 1 into l_exists
212: from WMS_ASN_DETAILS
213: where shipment_num = p_create_asn_details_rec.SHIPMENT_NUM
214: and organization_id = p_create_asn_details_rec.ORGANIZATION_ID
215: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
216: and ITEM_ID = p_create_asn_details_rec.ITEM_ID

Line 243: from WMS_ASN_DETAILS

239: BEGIN
240:
241: Begin
242: select 1 into l_exists
243: from WMS_ASN_DETAILS
244: where shipment_num = p_create_asn_details_rec.SHIPMENT_NUM
245: and organization_id = p_create_asn_details_rec.ORGANIZATION_ID
246: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
247: and ITEM_ID = p_create_asn_details_rec.ITEM_ID

Line 274: from WMS_ASN_DETAILS

270: BEGIN
271:
272: Begin
273: select 1 into l_exists
274: from WMS_ASN_DETAILS
275: where shipment_num = p_create_asn_details_rec.SHIPMENT_NUM
276: and organization_id = p_create_asn_details_rec.ORGANIZATION_ID
277: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
278: and ITEM_ID = p_create_asn_details_rec.ITEM_ID

Line 285: update WMS_ASN_DETAILS set

281: and rownum < 2
282: ;
283:
284: -- LPN is already there update the quantity
285: update WMS_ASN_DETAILS set
286: quantity_actual = nvl(quantity_actual, 0) + p_create_asn_details_rec.QUANTITY_ACTUAL,
287: lpn_actual = p_create_asn_details_rec.LPN_ACTUAL ,
288: last_update_date = sysdate,
289: last_updated_by = l_userid,

Line 323: from WMS_ASN_DETAILS

319: -- quantity of Lot added to the prev quantity.
320:
321: Begin
322: select 1 into l_exists
323: from WMS_ASN_DETAILS
324: where shipment_num = p_create_asn_details_rec.SHIPMENT_NUM
325: and organization_id = p_create_asn_details_rec.ORGANIZATION_ID
326: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
327: and ITEM_ID = p_create_asn_details_rec.ITEM_ID

Line 335: update WMS_ASN_DETAILS set

331: )
332: and rownum < 2
333: ;
334:
335: update WMS_ASN_DETAILS set
336: quantity_actual = nvl(quantity_actual,0) + p_create_asn_details_rec.QUANTITY_ACTUAL ,
337: lot_number_actual = p_create_asn_details_rec.LOT_NUMBER_ACTUAL,
338: lpn_actual = p_create_asn_details_rec.LPN_ACTUAL,
339: last_update_date = sysdate,

Line 367: from WMS_ASN_DETAILS

363: BEGIN
364:
365: Begin
366: select 1 into l_exists
367: from WMS_ASN_DETAILS
368: where shipment_num = p_create_asn_details_rec.SHIPMENT_NUM
369: and organization_id = p_create_asn_details_rec.ORGANIZATION_ID
370: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
371: and ITEM_ID = p_create_asn_details_rec.ITEM_ID

Line 395: from WMS_ASN_DETAILS

391: BEGIN
392:
393: Begin
394: select 1 into l_exists
395: from WMS_ASN_DETAILS
396: where shipment_num = p_create_asn_details_rec.SHIPMENT_NUM
397: and organization_id = p_create_asn_details_rec.ORGANIZATION_ID
398: and discrepancy_reporting_context = p_create_asn_details_rec.DISCREPANCY_REPORTING_CONTEXT
399: and ITEM_ID = p_create_asn_details_rec.ITEM_ID

Line 423: For c_item_details in ( select * from WMS_ASN_DETAILS

419: IS
420: l_exists number;
421: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
422: Begin
423: For c_item_details in ( select * from WMS_ASN_DETAILS
424: where shipment_num = p_shipment_num
425: and organization_id = p_organization_id
426: order by discrepancy_reporting_context
427: )

Line 482: from WMS_ASN_DETAILS

478: then
479: Begin
480: select 1
481: into l_exists
482: from WMS_ASN_DETAILS
483: where shipment_num=p_shipment_num
484: and organization_id = p_organization_id
485: and serial_number_actual = c_item_details.serial_number_expected
486: and lpn_actual = c_item_details.lpn_expected

Line 498: from WMS_ASN_DETAILS

494: then
495: Begin
496: select 1
497: into l_exists
498: from WMS_ASN_DETAILS
499: where shipment_num=p_shipment_num
500: and organization_id = p_organization_id
501: and serial_number_expected = c_item_details.serial_number_actual
502: and lpn_expected = c_item_details.lpn_actual

Line 822: update WMS_ASN_DETAILS set discrepancy_status = 'S'

818: /*
819: if (Check_discrepancy(l_create_asn_details_rec.shipment_num,
820: l_create_asn_details_rec.organization_id))
821: then
822: update WMS_ASN_DETAILS set discrepancy_status = 'S'
823: where shipment_num = l_create_asn_details_rec.SHIPMENT_NUM
824: and organization_id = l_create_asn_details_rec.organization_id
825: and discrepancy_reporting_context = 'I'
826: and item_id = l_create_asn_details_rec.item_id

Line 829: update WMS_ASN_DETAILS set discrepancy_status = 'F'

825: and discrepancy_reporting_context = 'I'
826: and item_id = l_create_asn_details_rec.item_id
827: ;
828: else
829: update WMS_ASN_DETAILS set discrepancy_status = 'F'
830: where shipment_num = l_create_asn_details_rec.SHIPMENT_NUM
831: and organization_id = l_create_asn_details_rec.organization_id
832: and discrepancy_reporting_context = 'I'
833: and item_id = l_create_asn_details_rec.item_id

Line 1072: update WMS_ASN_DETAILS set discrepancy_status = 'E'

1068: print_debug('Create ASN Details from interface : '|| l_progress ||' '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
1069: END IF;
1070:
1071: -- Update the Status
1072: update WMS_ASN_DETAILS set discrepancy_status = 'E'
1073: where shipment_num = l_create_asn_details_rec.SHIPMENT_NUM
1074: and organization_id = l_create_asn_details_rec.organization_id
1075: and discrepancy_reporting_context = 'I'
1076: and item_id = l_create_asn_details_rec.item_id

Line 1199: update WMS_ASN_DETAILS set discrepancy_status = 'S'

1195: if (Check_discrepancy(l_create_asn_details_rec.shipment_num,
1196: l_create_asn_details_rec.organization_id))
1197: then
1198:
1199: update WMS_ASN_DETAILS set discrepancy_status = 'S'
1200: where shipment_num = l_create_asn_details_rec.SHIPMENT_NUM
1201: and organization_id = l_create_asn_details_rec.organization_id
1202: and discrepancy_reporting_context = 'I'
1203: and item_id = l_create_asn_details_rec.item_id

Line 1207: update WMS_ASN_DETAILS set discrepancy_status = 'F'

1203: and item_id = l_create_asn_details_rec.item_id
1204: ;
1205: else
1206:
1207: update WMS_ASN_DETAILS set discrepancy_status = 'F'
1208: where shipment_num = l_create_asn_details_rec.SHIPMENT_NUM
1209: and organization_id = l_create_asn_details_rec.organization_id
1210: and discrepancy_reporting_context = 'I'
1211: and item_id = l_create_asn_details_rec.item_id