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 476: from bom_cto_order_lines_temp

472: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
473:
474: cursor eligible_lines_cur is
475: select line_id
476: from bom_cto_order_lines_temp
477: where status = 1
478: order by org_id;
479:
480: cursor oe_lines_cur (p_cursor_line_id number) is

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

589:
590: savepoint begin_line;
591:
592: IF PG_DEBUG <> 0 THEN
593: oe_debug_pub.add('auto_create_pur_req_cr: going to load eligible lines into bom_cto_order_lines_temp ' ,1);
594: END IF;
595:
596: -- load eligible lines into bcolt
597: load_lines_into_bcolt(p_sales_order_line_id,

Line 1034: update bom_cto_order_lines_temp

1030:
1031: close oe_lines_cur; -- Done processing the line. We will reopen cursor with new line_id.
1032:
1033: begin
1034: update bom_cto_order_lines_temp
1035: set status = 2 -- set status to completed
1036: where line_id = line_id_tab(tab_index)
1037: and status = 1;
1038: exception

Line 2418: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;

2414: where msi.inventory_item_id = exp.component_item_id
2415: and msi.organization_id = p_org_id);
2416:
2417: l_model_qty Number;
2418: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
2419: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;
2420: l_ato_line_id bom_cto_order_lines.ato_line_id%type;
2421: l_prim_qty Number;
2422: l_price_per_unit Number;

Line 2419: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;

2415: and msi.organization_id = p_org_id);
2416:
2417: l_model_qty Number;
2418: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
2419: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;
2420: l_ato_line_id bom_cto_order_lines.ato_line_id%type;
2421: l_prim_qty Number;
2422: l_price_per_unit Number;
2423: l_model_prim_uom Bom_cto_order_lines.order_quantity_uom%type;

Line 2420: l_ato_line_id bom_cto_order_lines.ato_line_id%type;

2416:
2417: l_model_qty Number;
2418: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
2419: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;
2420: l_ato_line_id bom_cto_order_lines.ato_line_id%type;
2421: l_prim_qty Number;
2422: l_price_per_unit Number;
2423: l_model_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
2424: l_ratio Number;

Line 2423: l_model_prim_uom Bom_cto_order_lines.order_quantity_uom%type;

2419: l_inventory_item_id Bom_cto_order_lines.inventory_item_id%type;
2420: l_ato_line_id bom_cto_order_lines.ato_line_id%type;
2421: l_prim_qty Number;
2422: l_price_per_unit Number;
2423: l_model_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
2424: l_ratio Number;
2425: l_price Number;
2426: l_prim_uom_qty Number;
2427: i Number := 0;

Line 3140: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;

3136: l_switch Boolean := TRUE;
3137: l_model_qty Number := 0;
3138: l_ratio Number;
3139: l_prim_uom_qty Number;
3140: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
3141: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3142: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3143: l_conv_qty Number;
3144: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;

Line 3142: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;

3138: l_ratio Number;
3139: l_prim_uom_qty Number;
3140: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
3141: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3142: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3143: l_conv_qty Number;
3144: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3145: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
3146: l_po_uom_qty Number;

Line 3144: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;

3140: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
3141: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3142: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3143: l_conv_qty Number;
3144: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3145: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
3146: l_po_uom_qty Number;
3147: l_config_item_id Mtl_system_items.inventory_item_id%type;
3148: i Number;

Line 3145: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;

3141: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3142: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3143: l_conv_qty Number;
3144: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3145: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;
3146: l_po_uom_qty Number;
3147: l_config_item_id Mtl_system_items.inventory_item_id%type;
3148: i Number;
3149: Cursor buy_comps_cur is

Line 3669: from bom_cto_order_lines

3665:
3666: If p_mode = 'ORDER' then
3667: select config_creation
3668: into l_config_creation
3669: from bom_cto_order_lines
3670: where line_id = p_line_id;
3671: End if;
3672:
3673: oe_debug_pub.add('Reduce_vendor_by_ou: Option specific = '||l_option_specific,1);

Line 3761: p_item_id IN bom_cto_order_lines.inventory_item_id%type,

3757:
3758:
3759:
3760: Procedure Derive_start_end_date(
3761: p_item_id IN bom_cto_order_lines.inventory_item_id%type,
3762: p_vendor_id IN Number,
3763: p_vendor_site_id IN Number,
3764: p_assgn_set_id IN Number ,
3765: x_start_date OUT NOCOPY date ,

Line 4153: from bom_cto_order_lines_upg

4149: end if;
4150:
4151: OPEN pprollup_cur FOR
4152: select distinct config_item_id
4153: from bom_cto_order_lines_upg
4154: where ato_line_id = line_id -- get only the parent configs
4155: and status = 'MRP_SRC';
4156:
4157: end if;

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

4784: -- rkaza. ireq project. 05/06/2005.
4785: -- Do not select lines that are in INTERNAL_REQ_REQUESTED status.
4786: -- Added it to the where clause along with PO_REQ_REQUESTED clause
4787: drive_mark := 0;
4788: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, status, inventory_item_id)'||
4789: 'select oel.line_id, oel.org_id, 1, 0 '||
4790: 'from oe_order_lines_all oel,'||
4791: ' mtl_system_items msi,'||
4792: ' wf_item_activity_statuses was,'||

Line 4995: update bom_cto_order_lines_temp

4991: BEGIN
4992:
4993: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4994:
4995: update bom_cto_order_lines_temp
4996: set status = p_status
4997: where line_id = p_line_id;
4998:
4999: EXCEPTION