APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 411: PO_SYSTEM_PARAMETERS_ALL PSP --

407: SELECT PLL.shipment_num
408: INTO x_po_shipment_num
409: FROM PO_LINE_LOCATIONS_MERGE_V PLL, --
410: PO_REQUISITION_LINES_ALL PRL, --
411: PO_SYSTEM_PARAMETERS_ALL PSP --
412: WHERE PLL.LINE_LOCATION_ID = x_line_location_to_check
413: AND pll.draft_id =PO_AUTOCREATE_PARAMS.g_draft_id
414: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
415: AND rtrim(NVL(PLL.note_to_receiver, '99')) = rtrim(NVL(x_note_to_receiver, '99'))

Line 484: po_system_parameters_all psp, --

480: po_requisition_lines_all prl, --
481: mtl_system_items msi,
482: po_line_types plt,
483: po_vendors pov,
484: po_system_parameters_all psp, --
485: financials_system_params_all fsp --
486: WHERE 1 =1
487: AND pli.item_id = msi.inventory_item_id( + )
488: AND NVL(msi.organization_id, fsp.inventory_organization_id) = fsp.inventory_organization_id

Line 532: PO_SYSTEM_PARAMETERS_ALL PSP, --

528: PO_REQUISITION_LINES_ALL PRL, --
529: --bug 1942696 hr_location changes to reflect the new view
530: MTL_SYSTEM_ITEMS MSI,
531: PO_LINE_TYPES PLT,
532: PO_SYSTEM_PARAMETERS_ALL PSP, --
533: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
534: PO_VENDORS POV,
535: PO_HEADERS_INTERFACE PHI
536: WHERE PLI.LINE_NUM = x_po_line_num

Line 621: PO_SYSTEM_PARAMETERS_ALL PSP, --

617: FROM PO_LINES_INTERFACE PLI,
618: PO_REQUISITION_LINES_ALL PRL, --
619: MTL_SYSTEM_ITEMS MSI,
620: PO_LINE_TYPES PLT,
621: PO_SYSTEM_PARAMETERS_ALL PSP, --
622: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
623: PO_VENDORS POV,
624: PO_HEADERS_INTERFACE PHI
625: WHERE PLI.LINE_NUM = x_po_line_num