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 783: oe_order_lines_all oel

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

Line 892: oe_order_lines_all oel,

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

Line 1211: from oe_order_lines_all oel

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

Line 1331: from oe_order_lines_all oel

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

Line 1877: from oe_order_lines_all oel,

1873: p_atp_table.Vendor_Site_Id ,
1874: p_atp_table.Insert_Flag ,
1875: p_atp_table.Error_Code ,
1876: p_atp_table.Message
1877: from oe_order_lines_all oel,
1878: oe_order_lines_all oel1,
1879: mtl_system_items msi
1880: where msi.inventory_item_id = oel.inventory_item_id
1881: and msi.organization_id = oel.ship_from_org_id

Line 1878: oe_order_lines_all oel1,

1874: p_atp_table.Insert_Flag ,
1875: p_atp_table.Error_Code ,
1876: p_atp_table.Message
1877: from oe_order_lines_all oel,
1878: oe_order_lines_all oel1,
1879: mtl_system_items msi
1880: where msi.inventory_item_id = oel.inventory_item_id
1881: and msi.organization_id = oel.ship_from_org_id
1882: and msi.bom_item_type = 1