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_CONFIG_BOM_PK dependencies on BOM_CTO_ORDER_LINES

Line 260: v_ato_line_id bom_cto_order_lines.ato_line_id%type ;

256: lErrBuf varchar2(80);
257: lTotLeadTime number := 0;
258: lOEValidationOrg number;
259:
260: v_ato_line_id bom_cto_order_lines.ato_line_id%type ;
261: v_program_id bom_cto_order_lines.program_id%type ;
262:
263: /* 2524562 Declaring variables */
264:

Line 261: v_program_id bom_cto_order_lines.program_id%type ;

257: lTotLeadTime number := 0;
258: lOEValidationOrg number;
259:
260: v_ato_line_id bom_cto_order_lines.ato_line_id%type ;
261: v_program_id bom_cto_order_lines.program_id%type ;
262:
263: /* 2524562 Declaring variables */
264:
265: v_missed_line_id number;

Line 280: from bom_cto_order_lines

276: cursor missed_lines ( xlineid number,
277: xconfigbillid number,
278: xEstRelDate date ) is /* Effectivity_date changes */
279: select line_id
280: from bom_cto_order_lines
281: where parent_ato_line_id=xlineid
282: and parent_ato_line_id <> line_id /* to avoid selecting top model */
283: minus
284: select revised_item_sequence_id /* new column used to store line_id */

Line 405: from bom_cto_order_lines

401: /* BUG #1957336 Change for preconfigure bom */
402:
403: select ato_line_id, program_id , header_id
404: into v_ato_line_id, v_program_id , v_header_id
405: from bom_cto_order_lines
406: where line_id = pLineId ;
407:
408:
409: /* BUG #1957336 Change for preconfigure bom */

Line 457: from bom_cto_order_lines

453: lStmtNum := 21;
454:
455: select nvl(schedule_ship_date,sysdate)
456: into g_SchShpDate
457: from bom_cto_order_lines
458: where line_id = pLineId ;
459: -- and ship_from_org_id = pOrgId ** bugfix 2312199 **
460: /* commented line as part of bugfix 2312199, the bug 1912376 was not fixed
461: ** properly, the bugfix will not work in case of sourced lower level models

Line 528: from bom_cto_order_lines bcol

524: loop
525: select bcol.line_id, bcol.inventory_item_id, bcol.parent_ato_line_id,
526: bcol.ordered_quantity
527: into lLineId, lModelId, lParentAtoLineId, lOrderedQty
528: from bom_cto_order_lines bcol
529: where bcol.line_id = lParentAtoLineId;
530:
531: IF PG_DEBUG <> 0 THEN
532: oe_debug_pub.add('create_bom_ml: ' || 'lLineId: ' || to_char(lLineId), 2);

Line 569: bom_cto_order_lines bcol,

565: select CAL.CALENDAR_DATE
566: into lEstRelDate
567: from bom_calendar_dates cal,
568: mtl_system_items msi,
569: bom_cto_order_lines bcol,
570: mtl_parameters mp
571: where msi.organization_id = pOrgId
572: and msi.inventory_item_id = pModelId
573: and bcol.line_id = pLineId

Line 813: bom_cto_order_lines bcol1, --Option

809: , nvl(ic1.basis_type,1), /* LBM project */
810: cto_msutil_pub.bom_batch_id
811: from
812: bom_inventory_components ic1,
813: bom_cto_order_lines bcol1, --Option
814: bom_cto_order_lines bcol2, -- Parent-Model
815: bom_cto_order_lines bcol3, -- Parent-component
816: mtl_system_items msi_child ,
817: mtl_system_items msi_parent

Line 814: bom_cto_order_lines bcol2, -- Parent-Model

810: cto_msutil_pub.bom_batch_id
811: from
812: bom_inventory_components ic1,
813: bom_cto_order_lines bcol1, --Option
814: bom_cto_order_lines bcol2, -- Parent-Model
815: bom_cto_order_lines bcol3, -- Parent-component
816: mtl_system_items msi_child ,
817: mtl_system_items msi_parent
818: -- begin bugfix 1653881

Line 815: bom_cto_order_lines bcol3, -- Parent-component

811: from
812: bom_inventory_components ic1,
813: bom_cto_order_lines bcol1, --Option
814: bom_cto_order_lines bcol2, -- Parent-Model
815: bom_cto_order_lines bcol3, -- Parent-component
816: mtl_system_items msi_child ,
817: mtl_system_items msi_parent
818: -- begin bugfix 1653881
819: where ic1.bill_sequence_id = ( -- this we find the assembly to which

Line 1084: bom_cto_order_lines bcol1, -- component

1080: bcol1.plan_level+1-bcol2.plan_level --plan_level
1081: , nvl(ic1.basis_type,1), /* LBM project */
1082: cto_msutil_pub.bom_batch_id
1083: from
1084: bom_cto_order_lines bcol1, -- component
1085: bom_cto_order_lines bcol2, -- Model
1086: mtl_system_items si1,
1087: mtl_system_items si2,
1088: bom_bill_of_materials b,

Line 1085: bom_cto_order_lines bcol2, -- Model

1081: , nvl(ic1.basis_type,1), /* LBM project */
1082: cto_msutil_pub.bom_batch_id
1083: from
1084: bom_cto_order_lines bcol1, -- component
1085: bom_cto_order_lines bcol2, -- Model
1086: mtl_system_items si1,
1087: mtl_system_items si2,
1088: bom_bill_of_materials b,
1089: bom_inventory_components ic1

Line 1321: from mtl_system_items_kfv msi, bom_cto_order_lines bcol

1317: select substrb(msi.concatenated_segments,1,50),
1318: 'Not Available' ,
1319: -1
1320: into v_missed_item,v_missed_line_number,v_order_number
1321: from mtl_system_items_kfv msi, bom_cto_order_lines bcol
1322: where msi.organization_id = bcol.ship_from_org_id
1323: and msi.inventory_item_id = bcol.inventory_item_id
1324: and bcol.line_id = v_missed_line_id;
1325:

Line 2063: bom_cto_order_lines bcol

2059: 0 --plan_level
2060: , 1, -- basis_type /* LBM project */
2061: cto_msutil_pub.bom_batch_id
2062: from
2063: bom_cto_order_lines bcol
2064: where bcol.line_id = pLineId
2065: and bcol.ordered_quantity <> 0
2066: and bcol.inventory_item_id = pModelId;
2067:

Line 4040: xLineId bom_cto_order_lines.line_id%TYPE,

4036: xMessageName out NOCOPY VARCHAR2)
4037: return integer is
4038:
4039: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
4040: xLineId bom_cto_order_lines.line_id%TYPE,
4041: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
4042: xSchShpdt date,
4043: xEstReldt date ) IS
4044: select bbm.organization_id,

Line 4088: from bom_cto_order_lines bcol1, -- COMPONENT

4084: bic.effectivity_date ,
4085: sysdate ) eff_date,
4086: nvl(bic.disable_date,g_futuredate) dis_date -- 3222932
4087: , nvl(bic.basis_type,1) basis_type /* LBM project */
4088: from bom_cto_order_lines bcol1, -- COMPONENT
4089: bom_cto_order_lines bcol2, -- MODEL
4090: mtl_system_items si1,
4091: mtl_system_items si2,
4092: bom_bill_of_materials bbm,

Line 4089: bom_cto_order_lines bcol2, -- MODEL

4085: sysdate ) eff_date,
4086: nvl(bic.disable_date,g_futuredate) dis_date -- 3222932
4087: , nvl(bic.basis_type,1) basis_type /* LBM project */
4088: from bom_cto_order_lines bcol1, -- COMPONENT
4089: bom_cto_order_lines bcol2, -- MODEL
4090: mtl_system_items si1,
4091: mtl_system_items si2,
4092: bom_bill_of_materials bbm,
4093: bom_inventory_components bic, -- Components

Line 4336: bom_cto_order_lines bcol1, -- Option

4332: nvl(ic1.disable_date,g_futuredate) -- 3222932
4333: , nvl(ic1.basis_type,1) /* LBM project */
4334: ,bcol3.inventory_item_id /* Bug Fix : 4147224 */
4335: from bom_inventory_components ic1,
4336: bom_cto_order_lines bcol1, -- Option
4337: bom_cto_order_lines bcol2, -- Parent-Model
4338: bom_cto_order_lines bcol3 , -- Parent-component
4339: mtl_system_items msi_child,
4340: mtl_system_items msi_parent

Line 4337: bom_cto_order_lines bcol2, -- Parent-Model

4333: , nvl(ic1.basis_type,1) /* LBM project */
4334: ,bcol3.inventory_item_id /* Bug Fix : 4147224 */
4335: from bom_inventory_components ic1,
4336: bom_cto_order_lines bcol1, -- Option
4337: bom_cto_order_lines bcol2, -- Parent-Model
4338: bom_cto_order_lines bcol3 , -- Parent-component
4339: mtl_system_items msi_child,
4340: mtl_system_items msi_parent
4341: where ic1.bill_sequence_id = (

Line 4338: bom_cto_order_lines bcol3 , -- Parent-component

4334: ,bcol3.inventory_item_id /* Bug Fix : 4147224 */
4335: from bom_inventory_components ic1,
4336: bom_cto_order_lines bcol1, -- Option
4337: bom_cto_order_lines bcol2, -- Parent-Model
4338: bom_cto_order_lines bcol3 , -- Parent-component
4339: mtl_system_items msi_child,
4340: mtl_system_items msi_parent
4341: where ic1.bill_sequence_id = (
4342: select common_bill_sequence_id

Line 4577: from bom_cto_order_lines bcol,

4573: bic.effectivity_date ,
4574: sysdate ),
4575: nvl(bic.disable_date,g_futuredate) -- 3222932
4576: , nvl(bic.basis_type,1) /* LBM project */
4577: from bom_cto_order_lines bcol,
4578: bom_bill_of_materials bbm,
4579: bom_inventory_components bic
4580: where bcol.line_id = pLineId
4581: and bcol.ordered_quantity <> 0