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.PO_SHARED_PROC_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 452: FROM po_requisition_lines_all prl

448: -- prevent procurement across OUs in this scenerio
449:
450: SELECT 'Y'
451: INTO l_valid_pa_project_referenced
452: FROM po_requisition_lines_all prl
453: WHERE prl.requisition_line_id = p_requisition_line_id
454: AND prl.destination_type_code = 'EXPENSE'
455: AND EXISTS
456: (SELECT 'valid pa information'

Line 556: l_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;

552: l_pa_project BOOLEAN := FALSE;
553: l_transaction_flow_status VARCHAR2(1);
554: l_dest_inv_org_ou_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
555: l_transaction_flow_header_id MTL_TRANSACTION_FLOW_HEADERS.header_id%TYPE;
556: l_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
557: l_api_name CONSTANT VARCHAR2 (30) := 'validate_cross_ou_purchasing';
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_dest_inv_org_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
560: l_owning_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 559: l_dest_inv_org_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;

555: l_transaction_flow_header_id MTL_TRANSACTION_FLOW_HEADERS.header_id%TYPE;
556: l_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
557: l_api_name CONSTANT VARCHAR2 (30) := 'validate_cross_ou_purchasing';
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_dest_inv_org_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
560: l_owning_org_id PO_HEADERS_ALL.org_id%TYPE;
561: l_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;
562: l_is_customer_location VARCHAR2(1) := 'N';
563: l_progress VARCHAR2(3) := '000';

Line 561: l_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;

557: l_api_name CONSTANT VARCHAR2 (30) := 'validate_cross_ou_purchasing';
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_dest_inv_org_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
560: l_owning_org_id PO_HEADERS_ALL.org_id%TYPE;
561: l_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;
562: l_is_customer_location VARCHAR2(1) := 'N';
563: l_progress VARCHAR2(3) := '000';
564: l_item_valid_status VARCHAR2(1);
565: l_item_valid_msg_name FND_NEW_MESSAGES.message_name%TYPE;

Line 567: l_purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE;

563: l_progress VARCHAR2(3) := '000';
564: l_item_valid_status VARCHAR2(1);
565: l_item_valid_msg_name FND_NEW_MESSAGES.message_name%TYPE;
566: x_app_name VARCHAR2(10);
567: l_purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE;
568: l_pou_bus_group_id HR_ALL_ORGANIZATION_UNITS.business_group_id%TYPE;
569: l_rou_bus_group_id HR_ALL_ORGANIZATION_UNITS.business_group_id%TYPE;
570: l_item_in_linv_pou VARCHAR2(1) := 'Y'; -- Bug 3433867
571:

Line 696: FROM po_requisition_lines_all prl, financials_system_params_all fsp

692: SELECT prl.category_id,
693: nvl(prl.destination_organization_id, fsp.inventory_organization_id),
694: prl.deliver_to_location_id
695: INTO l_category_id, l_dest_inv_org_id, l_deliver_to_location_id
696: FROM po_requisition_lines_all prl, financials_system_params_all fsp
697: WHERE prl.requisition_line_id = p_requisition_line_id
698: AND prl.org_id = fsp.org_id; -- Bug 3379488: Use base table for joins
699:
700: -- MC INVCONV START

Line 825: FROM po_requisition_lines_all prl,

821: hrou_req.business_group_id
822: INTO l_purchase_basis,
823: l_pou_bus_group_id,
824: l_rou_bus_group_id
825: FROM po_requisition_lines_all prl,
826: hr_all_organization_units hrou_po,
827: hr_all_organization_units hrou_req
828: WHERE prl.requisition_line_id = p_requisition_line_id
829: AND hrou_po.organization_id = p_purchasing_org_id

Line 904: FROM po_requisition_lines_all prl, financials_system_params_all fsp

900: nvl(prl.destination_organization_id,
901: fsp.inventory_organization_id),
902: prl.deliver_to_location_id
903: INTO l_category_id, l_dest_inv_org_id, l_deliver_to_location_id
904: FROM po_requisition_lines_all prl, financials_system_params_all fsp
905: WHERE prl.requisition_line_id = p_requisition_line_id
906: AND prl.org_id = fsp.org_id;
907:
908: l_progress := '018';