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_3PL_SEEDED_SOURCES dependencies on MTL_3PL_LOCATOR_OCCUPANCY

Line 539: from mtl_3pl_locator_occupancy inv

535: SELECT Trunc(greatest(last_receipt_date, Nvl(last_invoiced_date, last_receipt_date))) greater_date
536: , locator_id, client_code, organization_id, Trunc(transaction_date) txn_date, transaction_action_id ,
537: transaction_quantity , current_onhand, Trunc(last_receipt_date) last_rcpt_date,
538: number_of_days, Trunc(last_invoiced_date) last_inv_date
539: from mtl_3pl_locator_occupancy inv
540: WHERE client_code = p_client_code
541: and organization_id in (select organization_id from org_organization_definitions
542: where operating_unit = p_operating_unit_id)
543: and (( nvl(last_invoiced_date, p_source_to_date) <= p_source_to_date )

Line 619: FROM mtl_3pl_locator_occupancy

615:
616: BEGIN
617: SELECT 'Y'
618: INTO l_lock_record
619: FROM mtl_3pl_locator_occupancy
620: WHERE locator_id = locator_occupancy_rec.locator_id
621: AND organization_id = locator_occupancy_rec.organization_id
622: AND client_code = locator_occupancy_rec.client_code
623: FOR UPDATE NOWAIT;

Line 625: UPDATE mtl_3pl_locator_occupancy

621: AND organization_id = locator_occupancy_rec.organization_id
622: AND client_code = locator_occupancy_rec.client_code
623: FOR UPDATE NOWAIT;
624:
625: UPDATE mtl_3pl_locator_occupancy
626: SET number_of_days = l_new_number_of_days,
627: last_invoiced_date = l_invoice_date,
628: request_id= l_reqstid,
629: program_application_id = l_reqstid,

Line 641: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);

637: debug(' : Reset Number of days counter, rows updated -> '||sql%rowcount);
638:
639: EXCEPTION
640: WHEN OTHERS THEN
641: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
642: IF SQLCODE = -54 THEN
643: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
644: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
645: x_return_status := fnd_api.g_ret_sts_error;

Line 643: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');

639: EXCEPTION
640: WHEN OTHERS THEN
641: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
642: IF SQLCODE = -54 THEN
643: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
644: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
645: x_return_status := fnd_api.g_ret_sts_error;
646: x_counter_value := 0;
647: ELSE

Line 682: from mtl_3pl_locator_occupancy inv

678: SELECT Trunc(greatest(last_receipt_date, Nvl(last_invoiced_date, last_receipt_date))) greater_date
679: , locator_id, client_code, organization_id, Trunc(transaction_date) txn_date, transaction_action_id ,
680: transaction_quantity , current_onhand, Trunc(last_receipt_date) last_rcpt_date,
681: number_of_days, Trunc(last_invoiced_date) last_inv_date
682: from mtl_3pl_locator_occupancy inv
683: WHERE client_code = p_client_code
684: and organization_id in (select organization_id from org_organization_definitions
685: where operating_unit = p_operating_unit_id)
686: and (( nvl(last_invoiced_date, p_source_to_date) <= p_source_to_date )

Line 811: FROM mtl_3pl_locator_occupancy

807:
808: BEGIN
809: SELECT 'Y'
810: INTO l_lock_record
811: FROM mtl_3pl_locator_occupancy
812: WHERE locator_id = locator_occupancy_rec.locator_id
813: AND organization_id = locator_occupancy_rec.organization_id
814: AND client_code = locator_occupancy_rec.client_code
815: FOR UPDATE NOWAIT;

Line 817: UPDATE mtl_3pl_locator_occupancy

813: AND organization_id = locator_occupancy_rec.organization_id
814: AND client_code = locator_occupancy_rec.client_code
815: FOR UPDATE NOWAIT;
816:
817: UPDATE mtl_3pl_locator_occupancy
818: SET number_of_days = l_new_number_of_days,
819: last_invoiced_date = l_invoice_date,
820: request_id= l_reqstid,
821: program_application_id = l_reqstid,

Line 833: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);

829: debug(' : Reset Number of days counter, rows updated -> '||sql%rowcount);
830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
834: IF SQLCODE = -54 THEN
835: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
836: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
837: x_return_status := fnd_api.g_ret_sts_error;

Line 835: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');

831: EXCEPTION
832: WHEN OTHERS THEN
833: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
834: IF SQLCODE = -54 THEN
835: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
836: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
837: x_return_status := fnd_api.g_ret_sts_error;
838: x_counter_value := 0;
839: ELSE

Line 873: from mtl_3pl_locator_occupancy inv

869: SELECT Trunc(greatest(last_receipt_date, Nvl(last_invoiced_date, last_receipt_date))) greater_date
870: , locator_id, client_code, organization_id, Trunc(transaction_date) txn_date, transaction_action_id ,
871: transaction_quantity , current_onhand, Trunc(last_receipt_date) last_rcpt_date,
872: number_of_days, Trunc(last_invoiced_date) last_inv_date
873: from mtl_3pl_locator_occupancy inv
874: WHERE client_code = p_client_code
875: and organization_id in (select organization_id from org_organization_definitions
876: where operating_unit = p_operating_unit_id)
877: and (( nvl(last_invoiced_date, p_source_to_date) <= p_source_to_date )

Line 989: FROM mtl_3pl_locator_occupancy

985:
986: BEGIN
987: SELECT 'Y'
988: INTO l_lock_record
989: FROM mtl_3pl_locator_occupancy
990: WHERE locator_id = locator_occupancy_rec.locator_id
991: AND organization_id = locator_occupancy_rec.organization_id
992: AND client_code = locator_occupancy_rec.client_code
993: FOR UPDATE NOWAIT;

Line 995: UPDATE mtl_3pl_locator_occupancy

991: AND organization_id = locator_occupancy_rec.organization_id
992: AND client_code = locator_occupancy_rec.client_code
993: FOR UPDATE NOWAIT;
994:
995: UPDATE mtl_3pl_locator_occupancy
996: SET number_of_days = l_new_number_of_days,
997: last_invoiced_date = l_invoice_date,
998: request_id= l_reqstid,
999: program_application_id = l_reqstid,

Line 1011: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);

1007: debug(' : Reset Number of days counter, rows updated -> '||sql%rowcount);
1008:
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
1012: IF SQLCODE = -54 THEN
1013: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
1014: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
1015: x_return_status := fnd_api.g_ret_sts_error;

Line 1013: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');

1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
1012: IF SQLCODE = -54 THEN
1013: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
1014: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: x_counter_value := 0;
1017: ELSE