APPS.OE_UPG_SO_NEW dependencies on SO_LINE_DETAILS

Line 818: /* so_line_details sld */

814: from
815: so_lines_all sla,
816: so_line_attributes slattr,
817: oe_upgrade_wsh_iface sld
818: /* so_line_details sld */
819: where
820: sla.line_id = slattr.line_id (+) and
821: sla.header_id = G_header_id and
822: decode(sla.item_type_code,'SERVICE',

Line 4946: from so_line_details

4942: where parent_line_id=p_parent_line_id;
4943:
4944: cursor included_items(p_line_id IN NUMBER) IS
4945: select line_detail_id
4946: from so_line_details
4947: where line_id=p_line_id
4948: AND included_item_flag = 'Y';
4949:
4950: l_parent_line_id NUMBER := 0;

Line 4982: FROM SO_LINE_DETAILS

4978: END IF;
4979:
4980: SELECT count(*)
4981: INTO no_of_details
4982: FROM SO_LINE_DETAILS
4983: WHERE LINE_ID = l_parent_line_id
4984: AND INCLUDED_ITEM_FLAG = 'N'
4985: AND nvl(CONFIGURATION_ITEM_FLAG,'N') = 'N';
4986:

Line 4998: FROM SO_LINE_DETAILS

4994:
4995: BEGIN
4996: SELECT line_detail_id
4997: INTO l_detail_line_id
4998: FROM SO_LINE_DETAILS
4999: WHERE LINE_ID = l_parent_line_id
5000: AND INCLUDED_ITEM_FLAG = 'N'
5001: AND nvl(CONFIGURATION_ITEM_FLAG,'N') = 'N';
5002: EXCEPTION

Line 5027: FROM so_line_details

5023:
5024: BEGIN
5025: SELECT 'Y'
5026: INTO l_valid
5027: FROM so_line_details
5028: WHERE line_id=l_parent_line_id
5029: AND included_item_flag='Y'
5030: group by inventory_item_id
5031: having count(*) > 1;

Line 5098: FROM SO_LINE_DETAILS

5094: -- See if the option has multiple details
5095:
5096: SELECT count(*)
5097: INTO no_of_details
5098: FROM SO_LINE_DETAILS
5099: WHERE LINE_ID = l_option_line_id
5100: AND INVENTORY_ITEM_ID = l_inventory_item_id
5101: AND INCLUDED_ITEM_FLAG = 'N'
5102: AND nvl(CONFIGURATION_ITEM_FLAG,'N') = 'N';

Line 5117: FROM SO_LINE_DETAILS

5113: details */
5114: BEGIN
5115: SELECT line_detail_id
5116: INTO l_detail_line_id
5117: FROM SO_LINE_DETAILS
5118: WHERE LINE_ID = l_option_line_id
5119: AND INVENTORY_ITEM_ID = l_inventory_item_id
5120: AND INCLUDED_ITEM_FLAG = 'N'
5121: AND nvl(CONFIGURATION_ITEM_FLAG,'N') = 'N';

Line 5147: FROM so_line_details

5143: IF l_item_type_code = 'CLASS' THEN
5144: BEGIN
5145: SELECT 'Y'
5146: INTO l_valid
5147: FROM so_line_details
5148: WHERE line_id=l_option_line_id
5149: AND included_item_flag='Y'
5150: group by inventory_item_id
5151: having count(*) > 1;