[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
1216: ----------------------------------------------------------
1217: select nvl(master_organization_id,-99) -- bugfix 2646849: master_organization_id can be 0
1218: into lValidationOrg
1219: from oe_order_lines_all oel,
1220: oe_system_parameters_all ospa
1221: where oel.line_id = pLineid
1222: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
1223: and oel.inventory_item_id = pModelItemId;
1224:
2102: --cursor for retrieving components of a given top level ato model
2103: --added decode statement to populate wip supply type of null for top model ato
2104:
2105:
2106: cursor c1 ( c_organization_id oe_system_parameters_all.master_organization_id%type )
2107: is
2108: select OEOL.line_id
2109: , OEOL.top_model_line_id
2110: , OEOL.ato_line_id
2169: gUserID number ;
2170: gLoginId number ;
2171:
2172: v_inventory_item_id oe_order_lines_all.inventory_item_id%type ;
2173: v_organization_id oe_system_parameters_all.master_organization_id%type ;
2174:
2175: v_ato_line_id NUMBER;
2176: v_request_id NUMBER;
2177: v_program_id NUMBER;
2230: ---------------
2231: select master_organization_id
2232: into v_organization_id
2233: from oe_order_lines_all oel,
2234: oe_system_parameters_all ospa
2235: where oel.line_id = p_bcol_line_id
2236: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
2237: and oel.inventory_item_id = v_inventory_item_id ;
2238: */
5497: -----------
5498: select master_organization_id
5499: into v_organization_id
5500: from oe_order_lines_all oel,
5501: oe_system_parameters_all ospa
5502: where oel.line_id = p_ato_line_id
5503: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) ; --bug 1531691
5504: */
5505: