eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_AUTO_PROCURE_PK dependencies on BOM_CTO_ORDER_LINES

Line 124: | from oe_order_lines_all into bom_cto_order_lines_temp. Loop

120: |Jul 29 2004 Kaza
121: | Forward ported ct bugs 3590305 and 3599860.Significant changes
122: | to auto_create_purchase_req_cr. Please refer to the bug texts
123: | for details. In short, take a snapshot of eligible order lines
124: | from oe_order_lines_all into bom_cto_order_lines_temp. Loop
125: | thru the temp 1000 records at a time, lock each line
126: | individually, process and commit.
127: |
128: |Oct 26,2004 Kkonada

Line 253: p_item_id IN bom_cto_order_lines.inventory_item_id%type,

249: x_msg_count OUT NOCOPY Number,
250: x_msg_data OUT NOCOPY varchar2);
251:
252: Procedure Derive_start_end_date(
253: p_item_id IN bom_cto_order_lines.inventory_item_id%type,
254: p_vendor_id IN Number,
255: p_vendor_site_id IN Number,
256: p_assgn_set_id IN Number ,
257: x_start_date OUT NOCOPY date ,

Line 517: from bom_cto_order_lines_temp

513: --
514: /*
515: cursor eligible_lines_cur is
516: select line_id
517: from bom_cto_order_lines_temp
518: where status = 1
519: order by org_id;*/
520:
521: cursor eligible_lines_cur is

Line 525: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria

521: cursor eligible_lines_cur is
522: select bcolt.line_id line_id,
523: bcolt.org_id org_id,
524: Nvl(Sum(quantity),0) qty
525: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria
526: where bcolt.status = 1
527: and pria.interface_source_line_id(+) = bcolt.line_id
528: and pria.process_flag is null
529: group by bcolt.org_id, bcolt.line_id

Line 691: oe_debug_pub.add('auto_create_pur_req_cr: going to load eligible lines into bom_cto_order_lines_temp ' ,1);

687:
688: savepoint begin_line;
689:
690: IF PG_DEBUG <> 0 THEN
691: oe_debug_pub.add('auto_create_pur_req_cr: going to load eligible lines into bom_cto_order_lines_temp ' ,1);
692: END IF;
693:
694: -- load eligible lines into bcolt
695: load_lines_into_bcolt(p_sales_order_line_id,

Line 1195: update bom_cto_order_lines_temp

1191:
1192: close oe_lines_cur; -- Done processing the line. We will reopen cursor with new line_id.
1193:
1194: begin
1195: update bom_cto_order_lines_temp
1196: set status = 2 -- set status to completed
1197: where line_id = line_id_tab(tab_index).line_id --7559710
1198: and status = 1;
1199: exception

Line 1236: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria

1232: err_line_id number;
1233:
1234: cursor error_lines_cur is
1235: select bcolt.line_id
1236: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria
1237: where bcolt.status = 1
1238: and pria.interface_source_line_id(+) = bcolt.line_id
1239: and pria.process_flag = 'ERROR';
1240: begin

Line 2803: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;

2799: where msi.inventory_item_id = exp.component_item_id
2800: and msi.organization_id = p_org_id);
2801:
2802: l_model_qty Number;
2803: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
2804: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;
2805: l_ato_line_id bom_cto_order_lines.ato_line_id%type;
2806: l_prim_qty Number;
2807: l_price_per_unit Number;

Line 2804: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;

2800: and msi.organization_id = p_org_id);
2801:
2802: l_model_qty Number;
2803: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
2804: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;
2805: l_ato_line_id bom_cto_order_lines.ato_line_id%type;
2806: l_prim_qty Number;
2807: l_price_per_unit Number;
2808: l_model_prim_uom Bom_cto_order_lines.order_quantity_uom%type;

Line 2805: l_ato_line_id bom_cto_order_lines.ato_line_id%type;

2801:
2802: l_model_qty Number;
2803: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
2804: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;
2805: l_ato_line_id bom_cto_order_lines.ato_line_id%type;
2806: l_prim_qty Number;
2807: l_price_per_unit Number;
2808: l_model_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
2809: l_ratio Number;

Line 2808: l_model_prim_uom Bom_cto_order_lines.order_quantity_uom%type;

2804: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;
2805: l_ato_line_id bom_cto_order_lines.ato_line_id%type;
2806: l_prim_qty Number;
2807: l_price_per_unit Number;
2808: l_model_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
2809: l_ratio Number;
2810: l_price Number;
2811: l_prim_uom_qty Number;
2812: i Number := 0;

Line 3525: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;

3521: l_switch Boolean := TRUE;
3522: l_model_qty Number := 0;
3523: l_ratio Number;
3524: l_prim_uom_qty Number;
3525: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
3526: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3527: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3528: l_conv_qty Number;
3529: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;

Line 3527: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;

3523: l_ratio Number;
3524: l_prim_uom_qty Number;
3525: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
3526: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3527: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3528: l_conv_qty Number;
3529: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3530: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
3531: l_po_uom_qty Number;

Line 3529: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;

3525: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
3526: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3527: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3528: l_conv_qty Number;
3529: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3530: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
3531: l_po_uom_qty Number;
3532: l_config_item_id Mtl_system_items.inventory_item_id%type;
3533: i Number;

Line 3530: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;

3526: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3527: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3528: l_conv_qty Number;
3529: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3530: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
3531: l_po_uom_qty Number;
3532: l_config_item_id Mtl_system_items.inventory_item_id%type;
3533: i Number;
3534: Cursor buy_comps_cur is

Line 4079: from bom_cto_order_lines

4075:
4076: If p_mode = 'ORDER' then
4077: select config_creation
4078: into l_config_creation
4079: from bom_cto_order_lines
4080: where line_id = p_line_id;
4081: End if;
4082:
4083: oe_debug_pub.add('Reduce_vendor_by_ou: Option specific = '||l_option_specific,1);

Line 4171: p_item_id IN bom_cto_order_lines.inventory_item_id%type,

4167:
4168:
4169:
4170: Procedure Derive_start_end_date(
4171: p_item_id IN bom_cto_order_lines.inventory_item_id%type,
4172: p_vendor_id IN Number,
4173: p_vendor_site_id IN Number,
4174: p_assgn_set_id IN Number ,
4175: x_start_date OUT NOCOPY date ,

Line 4565: from bom_cto_order_lines_upg

4561: end if;
4562:
4563: OPEN pprollup_cur FOR
4564: select distinct config_item_id
4565: from bom_cto_order_lines_upg
4566: where ato_line_id = line_id -- get only the parent configs
4567: and status = 'MRP_SRC';
4568:
4569: end if;

Line 5200: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, status, inventory_item_id)'||

5196: -- rkaza. ireq project. 05/06/2005.
5197: -- Do not select lines that are in INTERNAL_REQ_REQUESTED status.
5198: -- Added it to the where clause along with PO_REQ_REQUESTED clause
5199: drive_mark := 0;
5200: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, status, inventory_item_id)'||
5201: 'select oel.line_id, oel.org_id, 1, 0 '||
5202: 'from oe_order_lines_all oel,'||
5203: ' mtl_system_items msi,'||
5204: ' wf_item_activity_statuses was,'||

Line 5416: update bom_cto_order_lines_temp

5412: BEGIN
5413:
5414: x_return_status := FND_API.G_RET_STS_SUCCESS ;
5415:
5416: update bom_cto_order_lines_temp
5417: set status = p_status
5418: where line_id = p_line_id;
5419:
5420: EXCEPTION