APPS.PO_DOCUMENT_UPDATE_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 1164: financials_system_parameters FSP

1160: FROM po_lines POL,
1161: po_line_types PLT,
1162: po_headers_all POHA,
1163: mtl_system_items_b MSI,
1164: financials_system_parameters FSP
1165: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)
1166: AND PLT.line_type_id = POL.line_type_id -- JOIN
1167: AND POHA.po_header_id(+) = POL.from_header_id -- JOIN
1168: AND MSI.inventory_item_id(+) = POL.item_id -- JOIN

Line 1320: financials_system_parameters FSP

1316: FROM po_line_locations PLL,
1317: po_lines POL,
1318: po_line_types PLT,
1319: mtl_system_items_b MSI,
1320: financials_system_parameters FSP
1321: WHERE PLL.line_location_id =
1322: NVL( p_chg.shipment_changes.parent_line_location_id(i), -- split shipment
1323: p_chg.shipment_changes.po_line_location_id(i) ) -- existing shipment
1324: AND POL.po_line_id = PLL.po_line_id -- JOIN

Line 1823: financials_system_parameters fsp

1819:
1820: SELECT NVL(mtl.grade_control_flag,'N')
1821: INTO l_grade_control_flag
1822: FROM mtl_system_items_b mtl,
1823: financials_system_parameters fsp
1824: WHERE mtl.inventory_item_id = p_chg.line_changes.c_item_id(i)
1825: AND mtl.organization_id = fsp.inventory_organization_id;
1826:
1827: IF l_grade_control_flag = 'N' THEN

Line 1847: financials_system_parameters fsp

1843: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1844: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1845: INTO l_dual_uom_ind,l_secondary_default_ind
1846: FROM mtl_system_items_b msi,
1847: financials_system_parameters fsp
1848: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1849: AND msi.organization_id = fsp.inventory_organization_id;
1850: ELSE
1851: l_dual_uom_ind := 'P';

Line 1887: financials_system_parameters fsp

1883: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1884: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1885: INTO l_dual_uom_ind,l_secondary_default_ind
1886: FROM mtl_system_items_b msi,
1887: financials_system_parameters fsp
1888: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1889: AND msi.organization_id = fsp.inventory_organization_id;
1890: ELSE
1891: l_dual_uom_ind := 'P';

Line 3451: FROM financials_system_parameters fsp;

3447: ***/
3448:
3449: SELECT fsp.inventory_organization_id
3450: INTO l_fsp_org_id
3451: FROM financials_system_parameters fsp;
3452:
3453: --g_sec_qty_grade_only_chge_doc := 'N' ;
3454:
3455: FOR i IN 1..p_chg.line_changes.get_count LOOP