[Home] [Help]
1326: BEGIN
1327:
1328: l_stmt_num := 10;
1329:
1330: -- Initialize all the standard variables.
1331: l_user_id := FND_GLOBAL.USER_ID;
1332: l_login_id := FND_GLOBAL.LOGIN_ID;
1333: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1334: l_application_id := FND_GLOBAL.RESP_APPL_ID;
1625: and mir1.inventory_item_id = msi.inventory_item_id
1626: and mir1.effectivity_date <= sysdate )
1627: and msi.revision_qty_control_code = 2 --revision controlled items only
1628: and msi.base_item_id is null -- not preconfig or config
1629: and msi.bom_item_type = 4; --standard item
1630:
1631: Exception when others then
1632: IF PG_DEBUG <> 0 THEN
1633: oe_debug_pub.add('Revision not populated because '||SQLERRM);
4126: -- for all the records with the status of REQ-CREATED
4127: --
4128: and (oel.item_type_code = 'CONFIG'
4129: or(oel.line_id=oel.ato_line_id
4130: and oel.item_type_code in ('STANDARD','OPTION')
4131: )
4132: )-- 4172156. Added Condition to pickup ATO item Line also
4133: and msi.replenish_to_order_flag = 'Y'
4134: and oel.ato_line_id is not null -- bugfix 3164399: although item_type_code will restrict
4808: 'and msi.replenish_to_order_flag = ''Y'' '||
4809: 'and oel.ato_line_id is not null ' ||
4810: 'and (oel.item_type_code = ''CONFIG'' '||
4811: ' or (oel.ato_line_id=oel.line_id '||
4812: ' and oel.item_type_code in (''STANDARD'', ''OPTION''))) '||
4813: 'and msi.pick_components_flag = ''N'' '||
4814: 'and was.item_type = ''OEOL'' '||
4815: 'and was.activity_status = ''NOTIFIED'' '||
4816: 'and was.item_type = wpa.activity_item_type '||
4859: sql_stmt := sql_stmt ||' and oel.line_id in (select oelc.line_id '||
4860: 'from oe_order_lines_all oelc '||
4861: 'where oelc.ato_line_id = :p_sales_order_line_id '||
4862: 'and (oelc.item_type_code = ''CONFIG'' '||
4863: ' or (oelc.item_type_code in (''STANDARD'',''OPTION'') '||
4864: ' and ato_line_id = line_id)) '||
4865: ') ';
4866: end if;
4867: