APPS.PO_DOCUMENT_UPDATE_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 1187: financials_system_parameters FSP

1183: FROM po_lines POL,
1184: po_line_types PLT,
1185: po_headers_all POHA,
1186: mtl_system_items_b MSI,
1187: financials_system_parameters FSP
1188: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)
1189: AND PLT.line_type_id = POL.line_type_id -- JOIN
1190: AND POHA.po_header_id(+) = POL.from_header_id -- JOIN
1191: AND MSI.inventory_item_id(+) = POL.item_id -- JOIN

Line 1343: financials_system_parameters FSP

1339: FROM po_line_locations PLL,
1340: po_lines POL,
1341: po_line_types PLT,
1342: mtl_system_items_b MSI,
1343: financials_system_parameters FSP
1344: WHERE PLL.line_location_id =
1345: NVL( p_chg.shipment_changes.parent_line_location_id(i), -- split shipment
1346: p_chg.shipment_changes.po_line_location_id(i) ) -- existing shipment
1347: AND POL.po_line_id = PLL.po_line_id -- JOIN

Line 1846: financials_system_parameters fsp

1842:
1843: SELECT NVL(mtl.grade_control_flag,'N')
1844: INTO l_grade_control_flag
1845: FROM mtl_system_items_b mtl,
1846: financials_system_parameters fsp
1847: WHERE mtl.inventory_item_id = p_chg.line_changes.c_item_id(i)
1848: AND mtl.organization_id = fsp.inventory_organization_id;
1849:
1850: IF l_grade_control_flag = 'N' THEN

Line 1870: financials_system_parameters fsp

1866: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1867: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1868: INTO l_dual_uom_ind,l_secondary_default_ind
1869: FROM mtl_system_items_b msi,
1870: financials_system_parameters fsp
1871: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1872: AND msi.organization_id = fsp.inventory_organization_id;
1873: ELSE
1874: l_dual_uom_ind := 'P';

Line 1910: financials_system_parameters fsp

1906: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1907: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1908: INTO l_dual_uom_ind,l_secondary_default_ind
1909: FROM mtl_system_items_b msi,
1910: financials_system_parameters fsp
1911: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1912: AND msi.organization_id = fsp.inventory_organization_id;
1913: ELSE
1914: l_dual_uom_ind := 'P';

Line 3474: FROM financials_system_parameters fsp;

3470: ***/
3471:
3472: SELECT fsp.inventory_organization_id
3473: INTO l_fsp_org_id
3474: FROM financials_system_parameters fsp;
3475:
3476: --g_sec_qty_grade_only_chge_doc := 'N' ;
3477:
3478: FOR i IN 1..p_chg.line_changes.get_count LOOP