[Home] [Help]
140: |
141: |
142: | Modified on 26-Mar-2004 By Sushant Sawant
143: | Fixed Bug#3484511
144: | all queries referencing oe_system_parameters_all
145: | should be replaced with a function call to oe_sys_parameters.value
146: |
147: |
148: | modified on 17-May-2004 Kiran Konada
1218: ----------------------------------------------------------
1219: select nvl(master_organization_id,-99) -- bugfix 2646849: master_organization_id can be 0
1220: into lValidationOrg
1221: from oe_order_lines_all oel,
1222: oe_system_parameters_all ospa
1223: where oel.line_id = pLineid
1224: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
1225: and oel.inventory_item_id = pModelItemId;
1226:
2104: --cursor for retrieving components of a given top level ato model
2105: --added decode statement to populate wip supply type of null for top model ato
2106:
2107:
2108: cursor c1 ( c_organization_id oe_system_parameters_all.master_organization_id%type )
2109: is
2110: select OEOL.line_id
2111: , OEOL.top_model_line_id
2112: , OEOL.ato_line_id
2171: gUserID number ;
2172: gLoginId number ;
2173:
2174: v_inventory_item_id oe_order_lines_all.inventory_item_id%type ;
2175: v_organization_id oe_system_parameters_all.master_organization_id%type ;
2176:
2177: v_ato_line_id NUMBER;
2178: v_request_id NUMBER;
2179: v_program_id NUMBER;
2232: ---------------
2233: select master_organization_id
2234: into v_organization_id
2235: from oe_order_lines_all oel,
2236: oe_system_parameters_all ospa
2237: where oel.line_id = p_bcol_line_id
2238: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
2239: and oel.inventory_item_id = v_inventory_item_id ;
2240: */
5521: -----------
5522: select master_organization_id
5523: into v_organization_id
5524: from oe_order_lines_all oel,
5525: oe_system_parameters_all ospa
5526: where oel.line_id = p_ato_line_id
5527: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) ; --bug 1531691
5528: */
5529: