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.RCV_GML_CONV_MIG dependencies on RCV_LOTS_SUPPLY

Line 31: --Call proc to update lots with migrated lot number in rcv_lots_supply.

27:
28: --Call proc to update secondary unit of measure and secondary quantity in rcv_supply.
29: Update_rcv_supply;
30:
31: --Call proc to update lots with migrated lot number in rcv_lots_supply.
32: Update_rcv_lots_supply;
33:
34: END rcv_mig_gml_data;
35:

Line 32: Update_rcv_lots_supply;

28: --Call proc to update secondary unit of measure and secondary quantity in rcv_supply.
29: Update_rcv_supply;
30:
31: --Call proc to update lots with migrated lot number in rcv_lots_supply.
32: Update_rcv_lots_supply;
33:
34: END rcv_mig_gml_data;
35:
36:

Line 471: -- update_rcv_lots_supply

467: END Update_rcv_supply;
468:
469: /*===========================================================================
470: -- PROCEDURE:
471: -- update_rcv_lots_supply
472: --
473: -- DESCRIPTION:
474: -- This PL/SQL procedure is used to Update RCV_LOTS_SUPPLY for LOT_NUM
475: --

Line 474: -- This PL/SQL procedure is used to Update RCV_LOTS_SUPPLY for LOT_NUM

470: -- PROCEDURE:
471: -- update_rcv_lots_supply
472: --
473: -- DESCRIPTION:
474: -- This PL/SQL procedure is used to Update RCV_LOTS_SUPPLY for LOT_NUM
475: --
476: -- PARAMETERS:
477: -- None
478: --

Line 480: -- update_rcv_lots_supply;

476: -- PARAMETERS:
477: -- None
478: --
479: -- SYNOPSIS:
480: -- update_rcv_lots_supply;
481: --
482: -- HISTORY
483: -- P. Bamb 10-May-2005 Created
484: --=========================================================================== */

Line 485: PROCEDURE update_rcv_lots_supply IS

481: --
482: -- HISTORY
483: -- P. Bamb 10-May-2005 Created
484: --=========================================================================== */
485: PROCEDURE update_rcv_lots_supply IS
486:
487: CURSOR CR_GET_LOT_SUPPLY IS
488: SELECT rls.rowid,
489: rls.transaction_id transaction_id,

Line 500: rcv_lots_supply rls,

496: rt.locator_id locator_id,
497: rls.reason_code,
498: rsl.item_id
499: FROM rcv_transactions rt ,
500: rcv_lots_supply rls,
501: rcv_shipment_lines rsl,
502: mtl_parameters mp
503: WHERE rls.supply_type_code = 'RECEIVING'
504: and rls.transaction_id = rt.transaction_id

Line 512: WHERE table_name = 'RCV_LOTS_SUPPLY'

508: AND rt.shipment_line_id = rsl.shipment_line_id
509: AND mp.process_enabled_flag = 'Y'
510: and not exists
511: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
512: WHERE table_name = 'RCV_LOTS_SUPPLY'
513: and glm.transaction_id = rls.transaction_id
514: and glm.shipment_line_id = rls.shipment_line_id)
515: --ignore fulfilled supply rows
516: AND (rls.shipment_line_id,rls.lot_num) IN

Line 518: FROM rcv_lots_supply rl

514: and glm.shipment_line_id = rls.shipment_line_id)
515: --ignore fulfilled supply rows
516: AND (rls.shipment_line_id,rls.lot_num) IN
517: (SELECT rl.shipment_line_id,rl.lot_num
518: FROM rcv_lots_supply rl
519: WHERE rl.supply_type_code = 'RECEIVING'
520: GROUP BY rl.shipment_line_id,rl.lot_num
521: HAVING SUM(rl.quantity) > 0)
522: ORDER BY rls.transaction_id;

Line 536: from rcv_lots_supply rlt ,

532: rsl.to_subinventory subinventory,
533: rsl.locator_id locator_id,
534: rlt.reason_code reason_code,
535: rlt.transaction_id
536: from rcv_lots_supply rlt ,
537: rcv_shipment_lines rsl,
538: mtl_parameters mp
539: WHERE rlt.supply_type_code = 'SHIPMENT'
540: and rsl.shipment_line_id = rlt.shipment_line_id

Line 547: FROM rcv_lots_supply rl

543: AND mp.process_enabled_flag = 'Y'
544: --ignore fulfilled supply rows
545: AND (rlt.shipment_line_id,rlt.lot_num) IN
546: (SELECT rl.shipment_line_id,rl.lot_num
547: FROM rcv_lots_supply rl
548: WHERE rl.supply_type_code = 'SHIPMENT'
549: GROUP BY rl.shipment_line_id,rl.lot_num
550: HAVING SUM(rl.quantity) > 0)
551: /*and not exists

Line 553: WHERE table_name = 'RCV_LOTS_SUPPLY'

549: GROUP BY rl.shipment_line_id,rl.lot_num
550: HAVING SUM(rl.quantity) > 0)
551: /*and not exists
552: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
553: WHERE table_name = 'RCV_LOTS_SUPPLY'
554: And glm.shipment_line_id = rls.shipment_line_id)*/
555: ORDER BY rsl.shipment_line_id
556: FOR UPDATE OF LOT_NUM;
557:

Line 597: UPDATE rcv_lots_supply

593: --Call INVENTORY API that returns the new Lot number for the item, organization, lot, sublot,
594: -- Subinventory and Locator
595: --For any errors raise exception rcv_lot_transactions_data;
596:
597: UPDATE rcv_lots_supply
598: SET LOT_NUM = l_lot_num,
599: REASON_ID = l_reason_id
600: WHERE rowid = cr_rec.rowid;
601:

Line 612: VALUES ( 'RCV_LOTS_SUPPLY',

608: CREATED_BY,
609: CREATION_DATE,
610: LAST_UPDATED_BY,
611: LAST_UPDATE_DATE)
612: VALUES ( 'RCV_LOTS_SUPPLY',
613: cr_rec.transaction_id,
614: NULL,
615: cr_rec.shipment_line_id,
616: NULL,

Line 665: UPDATE rcv_lots_supply

661: --Call INVENTORY API that returns the new Lot number for the item, organization, lot, sublot,
662: -- Subinventory and Locator
663: --For any errors raise exception rcv_lot_transactions_data;
664:
665: UPDATE rcv_lots_supply
666: SET LOT_NUM = l_lot_num,
667: REASON_ID = l_reason_id
668: WHERE rowid = cr_rec1.rowid;
669:

Line 680: VALUES ( 'RCV_LOTS_SUPPLY',

676: CREATED_BY,
677: CREATION_DATE,
678: LAST_UPDATED_BY,
679: LAST_UPDATE_DATE)
680: VALUES ( 'RCV_LOTS_SUPPLY',
681: cr_rec1.transaction_id,
682: NULL,
683: cr_rec1.shipment_line_id,
684: NULL,

Line 706: END Update_rcv_lots_supply;

702: 'ERROR DERIVING LOT_NUM-'||substr(l_errm,1,1975),sysdate,sysdate);
703: END;
704: END LOOP;
705: COMMIT;
706: END Update_rcv_lots_supply;
707:
708: END RCV_GML_CONV_MIG;
709: