DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on OE_ORDER_LINES_ALL

Line 172: l_line_id oe_order_lines_all.line_id%type;

168: and bcol.config_item_id is not null
169: and bcol.ato_line_id is not null
170: order by plan_level desc;
171:
172: l_line_id oe_order_lines_all.line_id%type;
173: l_config_item_id oe_order_lines_all.inventory_item_id%type;
174: l_rcv_org_id oe_order_lines_all.ship_from_org_id%type;
175:
176:

Line 173: l_config_item_id oe_order_lines_all.inventory_item_id%type;

169: and bcol.ato_line_id is not null
170: order by plan_level desc;
171:
172: l_line_id oe_order_lines_all.line_id%type;
173: l_config_item_id oe_order_lines_all.inventory_item_id%type;
174: l_rcv_org_id oe_order_lines_all.ship_from_org_id%type;
175:
176:
177: v_bcol_count number:= 0 ;

Line 174: l_rcv_org_id oe_order_lines_all.ship_from_org_id%type;

170: order by plan_level desc;
171:
172: l_line_id oe_order_lines_all.line_id%type;
173: l_config_item_id oe_order_lines_all.inventory_item_id%type;
174: l_rcv_org_id oe_order_lines_all.ship_from_org_id%type;
175:
176:
177: v_bcol_count number:= 0 ;
178: BEGIN

Line 786: oe_order_lines_all oel

782: select (ceil(nvl(msi.fixed_lead_time,0)
783: + nvl(msi.variable_lead_time,0) * oel.ordered_quantity))
784: into lLeadTime
785: from mtl_system_items msi,
786: oe_order_lines_all oel
787: where oel.line_id = pLineId
788: and msi.inventory_item_id = oel.inventory_item_id
789: and msi.organization_id = oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id);
790: end if;

Line 895: oe_order_lines_all oel,

891: into v_missed_item,
892: v_missed_line_number,
893: v_order_number
894: from mtl_system_items_kfv msi,
895: oe_order_lines_all oel,
896: oe_order_headers_all oeh
897: ,bom_cto_order_lines bcol
898: where msi.organization_id = oel.ship_from_org_id
899: and msi.inventory_item_id = oel.inventory_item_id

Line 1214: from oe_order_lines_all oel

1210: v_problem_model_line_num := ' -1 ' ;
1211: else
1212: select oel.line_number || '.' || oel.shipment_number
1213: into v_problem_model_line_num
1214: from oe_order_lines_all oel
1215: where line_id = pLineId ;
1216: end if;
1217: oe_debug_pub.add( ' DROPPED ITEM INFO: ' ||
1218: ' Problem Model ' || v_problem_model ||

Line 1334: from oe_order_lines_all oel

1330:
1331:
1332: select oel.line_number || '.' || oel.shipment_number
1333: into v_problem_model_line_num
1334: from oe_order_lines_all oel
1335: where line_id = pLineId ;
1336: v_table_count := CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE.count + 1 ;
1337: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).PROCESS := 'NOTIFY_OID_INC' ; /* ITEM NOT CREATED */
1338: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).LINE_ID := pLineId ;

Line 1937: from oe_order_lines_all oel,

1933: p_atp_table.Vendor_Site_Id ,
1934: p_atp_table.Insert_Flag ,
1935: p_atp_table.Error_Code ,
1936: p_atp_table.Message
1937: from oe_order_lines_all oel,
1938: oe_order_lines_all oel1,
1939: mtl_system_items msi
1940: where msi.inventory_item_id = oel.inventory_item_id
1941: and msi.organization_id = oel.ship_from_org_id

Line 1938: oe_order_lines_all oel1,

1934: p_atp_table.Insert_Flag ,
1935: p_atp_table.Error_Code ,
1936: p_atp_table.Message
1937: from oe_order_lines_all oel,
1938: oe_order_lines_all oel1,
1939: mtl_system_items msi
1940: where msi.inventory_item_id = oel.inventory_item_id
1941: and msi.organization_id = oel.ship_from_org_id
1942: and msi.bom_item_type = 1