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.EAM_PROCESS_WO_UTIL_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 195: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions : inserting into po_requisitions_interface_all ..'); END IF;

191:
192: end if;
193:
194:
195: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions : inserting into po_requisitions_interface_all ..'); END IF;
196:
197: /* Changed for MOAC: Insert org_id as well */
198: insert into po_requisitions_interface_all (
199: interface_source_code,

Line 198: insert into po_requisitions_interface_all (

194:
195: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions : inserting into po_requisitions_interface_all ..'); END IF;
196:
197: /* Changed for MOAC: Insert org_id as well */
198: insert into po_requisitions_interface_all (
199: interface_source_code,
200: destination_type_code,
201: authorization_status,
202: preparer_id, -- person id of the user name

Line 494: /Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450/

490:
491:
492: IF l_di_record.direct_item_type_id = 1 THEN -- description based direct item . fix for 3421830
493: BEGIN
494: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
495: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
496: FROM
497: (SELECT SUM(nvl(quantity,0)) req_qty
498: FROM po_requisitions_interface_all pria

Line 498: FROM po_requisitions_interface_all pria

494: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
495: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
496: FROM
497: (SELECT SUM(nvl(quantity,0)) req_qty
498: FROM po_requisitions_interface_all pria
499: WHERE pria.wip_entity_id =l_di_record.wip_entity_id
500: AND pria.destination_organization_id = l_di_record.organization_id
501: AND pria.wip_operation_seq_num = l_di_record.task_number
502: AND pria.item_id is null

Line 530: /Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450/

526: ELSE
527:
528:
529: BEGIN
530: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
531: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
532: FROM
533: (SELECT SUM(nvl(quantity,0)) req_qty
534: FROM po_requisitions_interface_all pria

Line 534: FROM po_requisitions_interface_all pria

530: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
531: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
532: FROM
533: (SELECT SUM(nvl(quantity,0)) req_qty
534: FROM po_requisitions_interface_all pria
535: WHERE pria.wip_entity_id = l_di_record.wip_entity_id
536: AND pria.destination_organization_id = l_di_record.organization_id
537: AND pria.wip_operation_seq_num = l_di_record.task_number
538: AND pria.item_id = l_di_record.inventory_item_id