DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 485: financials_system_params_all fsp --

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
489: --AND pli.line_type_id = plt.line_type_id

Line 533: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

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
537: AND PLI.shipment_num IS NOT NULL

Line 622: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

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
626: AND PLI.shipment_num IS NOT NULL