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 403: from bom_cto_order_lines

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

Line 455: from bom_cto_order_lines

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

Line 526: from bom_cto_order_lines bcol

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

Line 567: bom_cto_order_lines bcol,

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

Line 811: bom_cto_order_lines bcol1, --Option

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

Line 812: bom_cto_order_lines bcol2, -- Parent-Model

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

Line 813: bom_cto_order_lines bcol3, -- Parent-component

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

Line 1059: bom_cto_order_lines bcol1, -- component

1055: bcol1.plan_level+1-bcol2.plan_level --plan_level
1056: , nvl(ic1.basis_type,1), /* LBM project */
1057: cto_msutil_pub.bom_batch_id
1058: from
1059: bom_cto_order_lines bcol1, -- component
1060: bom_cto_order_lines bcol2, -- Model
1061: mtl_system_items si1,
1062: mtl_system_items si2,
1063: bom_bill_of_materials b,

Line 1060: bom_cto_order_lines bcol2, -- Model

1056: , nvl(ic1.basis_type,1), /* LBM project */
1057: cto_msutil_pub.bom_batch_id
1058: from
1059: bom_cto_order_lines bcol1, -- component
1060: bom_cto_order_lines bcol2, -- Model
1061: mtl_system_items si1,
1062: mtl_system_items si2,
1063: bom_bill_of_materials b,
1064: bom_inventory_components ic1

Line 1295: from mtl_system_items_kfv msi, bom_cto_order_lines bcol

1291: select substrb(msi.concatenated_segments,1,50),
1292: 'Not Available' ,
1293: -1
1294: into v_missed_item,v_missed_line_number,v_order_number
1295: from mtl_system_items_kfv msi, bom_cto_order_lines bcol
1296: where msi.organization_id = bcol.ship_from_org_id
1297: and msi.inventory_item_id = bcol.inventory_item_id
1298: and bcol.line_id = v_missed_line_id;
1299:

Line 2037: bom_cto_order_lines bcol

2033: 0 --plan_level
2034: , 1, -- basis_type /* LBM project */
2035: cto_msutil_pub.bom_batch_id
2036: from
2037: bom_cto_order_lines bcol
2038: where bcol.line_id = pLineId
2039: and bcol.ordered_quantity <> 0
2040: and bcol.inventory_item_id = pModelId;
2041:

Line 3861: xLineId bom_cto_order_lines.line_id%TYPE,

3857: xMessageName out NOCOPY VARCHAR2)
3858: return integer is
3859:
3860: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
3861: xLineId bom_cto_order_lines.line_id%TYPE,
3862: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
3863: xSchShpdt date,
3864: xEstReldt date ) IS
3865: select bbm.organization_id,

Line 3909: from bom_cto_order_lines bcol1, -- COMPONENT

3905: bic.effectivity_date ,
3906: sysdate ) eff_date,
3907: nvl(bic.disable_date,g_futuredate) dis_date -- 3222932
3908: , nvl(bic.basis_type,1) basis_type /* LBM project */
3909: from bom_cto_order_lines bcol1, -- COMPONENT
3910: bom_cto_order_lines bcol2, -- MODEL
3911: mtl_system_items si1,
3912: mtl_system_items si2,
3913: bom_bill_of_materials bbm,

Line 3910: bom_cto_order_lines bcol2, -- MODEL

3906: sysdate ) eff_date,
3907: nvl(bic.disable_date,g_futuredate) dis_date -- 3222932
3908: , nvl(bic.basis_type,1) basis_type /* LBM project */
3909: from bom_cto_order_lines bcol1, -- COMPONENT
3910: bom_cto_order_lines bcol2, -- MODEL
3911: mtl_system_items si1,
3912: mtl_system_items si2,
3913: bom_bill_of_materials bbm,
3914: bom_inventory_components bic, -- Components

Line 4153: bom_cto_order_lines bcol1, -- Option

4149: nvl(ic1.disable_date,g_futuredate) -- 3222932
4150: , nvl(ic1.basis_type,1) /* LBM project */
4151: ,bcol3.inventory_item_id /* Bug Fix : 4147224 */
4152: from bom_inventory_components ic1,
4153: bom_cto_order_lines bcol1, -- Option
4154: bom_cto_order_lines bcol2, -- Parent-Model
4155: bom_cto_order_lines bcol3 , -- Parent-component
4156: mtl_system_items msi_child,
4157: mtl_system_items msi_parent

Line 4154: bom_cto_order_lines bcol2, -- Parent-Model

4150: , nvl(ic1.basis_type,1) /* LBM project */
4151: ,bcol3.inventory_item_id /* Bug Fix : 4147224 */
4152: from bom_inventory_components ic1,
4153: bom_cto_order_lines bcol1, -- Option
4154: bom_cto_order_lines bcol2, -- Parent-Model
4155: bom_cto_order_lines bcol3 , -- Parent-component
4156: mtl_system_items msi_child,
4157: mtl_system_items msi_parent
4158: where ic1.bill_sequence_id = (

Line 4155: bom_cto_order_lines bcol3 , -- Parent-component

4151: ,bcol3.inventory_item_id /* Bug Fix : 4147224 */
4152: from bom_inventory_components ic1,
4153: bom_cto_order_lines bcol1, -- Option
4154: bom_cto_order_lines bcol2, -- Parent-Model
4155: bom_cto_order_lines bcol3 , -- Parent-component
4156: mtl_system_items msi_child,
4157: mtl_system_items msi_parent
4158: where ic1.bill_sequence_id = (
4159: select common_bill_sequence_id

Line 4389: from bom_cto_order_lines bcol,

4385: bic.effectivity_date ,
4386: sysdate ),
4387: nvl(bic.disable_date,g_futuredate) -- 3222932
4388: , nvl(bic.basis_type,1) /* LBM project */
4389: from bom_cto_order_lines bcol,
4390: bom_bill_of_materials bbm,
4391: bom_inventory_components bic
4392: where bcol.line_id = pLineId
4393: and bcol.ordered_quantity <> 0