APPS.PJM_UNIT_EFF dependencies on MTL_SERIAL_NUMBERS

Line 785: FROM mtl_serial_numbers

781: , X_organization_id );
782:
783: SELECT end_item_unit_number
784: INTO L_serial_unitnum
785: FROM mtl_serial_numbers
786: WHERE serial_number = X_serial_number
787: AND inventory_item_id = X_item_id;
788:
789: --

Line 948: UPDATE mtl_serial_numbers

944: else
945: L_unit_number := RMA_Rcpt_Unit_Number(L_rcv_trx_id);
946: end if;
947:
948: UPDATE mtl_serial_numbers
949: SET end_item_unit_number =
950: DECODE(L_direction, 1, L_unit_number, NULL)
951: WHERE (inventory_item_id, serial_number) in (
952: SELECT inventory_item_id, serial_number