DBA Data[Home] [Help]

APPS.WMS_EPC_PVT dependencies on MTL_CROSS_REFERENCES_B

Line 313: FROM mtl_cross_references_b

309: --leave it null
310:
311: BEGIN
312: SELECT Nvl(epc_gtin_serial,0) INTO l_cur_serial_num
313: FROM mtl_cross_references_b
314: WHERE CROSS_REFERENCE = To_char(p_gtin)
315: AND cross_reference_type = G_PROFILE_GTIN
316: AND inventory_item_id = p_item_id
317: AND uom_code = p_uom_code

Line 341: UPDATE mtl_cross_references_b

337:
338: --update the table
339: BEGIN
340:
341: UPDATE mtl_cross_references_b
342: SET epc_gtin_serial = l_new_serial
343: WHERE CROSS_REFERENCE = To_char(p_gtin)
344: AND cross_reference_type = G_PROFILE_GTIN
345: AND inventory_item_id = p_item_id