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_UPDATE_BOM_RTG_PK dependencies on BOM_CTO_ORDER_LINES_UPG

Line 151: from bom_cto_order_lines_upg bcolu

147:
148: CURSOR c_boms IS
149: select distinct
150: bcolu.ato_line_id ato_line_id
151: from bom_cto_order_lines_upg bcolu
152: where bcolu.sequence = p_seq
153: and bcolu.status = 'BOM_PROC'
154: and bcolu.ato_line_id = bcolu.line_id;
155:

Line 157: select /+ INDEX (BCOLU BOM_CTO_ORDER_LINES_UPG_N4) /

153: and bcolu.status = 'BOM_PROC'
154: and bcolu.ato_line_id = bcolu.line_id;
155:
156: CURSOR c_all_configs(p_ato_line_id number) IS
157: select /*+ INDEX (BCOLU BOM_CTO_ORDER_LINES_UPG_N4) */
158: bcolu.line_id,
159: bcolu.inventory_item_id,
160: bcolu.config_item_id
161: from bom_cto_order_lines_upg bcolu

Line 161: from bom_cto_order_lines_upg bcolu

157: select /*+ INDEX (BCOLU BOM_CTO_ORDER_LINES_UPG_N4) */
158: bcolu.line_id,
159: bcolu.inventory_item_id,
160: bcolu.config_item_id
161: from bom_cto_order_lines_upg bcolu
162: where bcolu.ato_line_id = p_ato_line_id
163: and bcolu.bom_item_type = 1
164: and nvl(bcolu.wip_supply_type,0) <> 6
165: and bcolu.config_item_id is not null

Line 196: update bom_cto_order_lines_upg bcolu

192: --
193: -- select next N ato_line_ids and update status to BOM_PROC
194: --
195: l_stmt_num := 20;
196: update bom_cto_order_lines_upg bcolu
197: set status = 'BOM_PROC'
198: where bcolu.ato_line_id in (select ato_line_id
199: from bom_cto_order_lines_upg bcolu2
200: where bcolu2.ato_line_id = bcolu2.line_id

Line 199: from bom_cto_order_lines_upg bcolu2

195: l_stmt_num := 20;
196: update bom_cto_order_lines_upg bcolu
197: set status = 'BOM_PROC'
198: where bcolu.ato_line_id in (select ato_line_id
199: from bom_cto_order_lines_upg bcolu2
200: where bcolu2.ato_line_id = bcolu2.line_id
201: and bcolu2.sequence = p_seq
202: and bcolu2.status = 'CTO_SRC'
203: and rownum < G_SUB_BATCH_SIZE + 1);

Line 222: select /+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_U1) /

218: -- being found for the same config item on a different order line
219: -- Process only if line is not on hold
220: --
221: l_stmt_num := 35;
222: select /*+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_U1) */
223: status
224: into l_bcolu_status
225: from bom_cto_order_lines_upg
226: where ato_line_id = v_boms.ato_line_id

Line 225: from bom_cto_order_lines_upg

221: l_stmt_num := 35;
222: select /*+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_U1) */
223: status
224: into l_bcolu_status
225: from bom_cto_order_lines_upg
226: where ato_line_id = v_boms.ato_line_id
227: and rownum = 1;
228:
229: WriteToLog('Line is in status :: '||l_bcolu_status, 2);

Line 240: select /+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4) /

236: WriteToLog('In v_boms loop, ato_line_id:: '||v_boms.ato_line_id, 4);
237:
238:
239:
240: select /*+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4) */
241: status
242: into l_bcolu_status
243: from bom_cto_order_lines_upg
244: where line_id = v_all_configs.line_id ;

Line 243: from bom_cto_order_lines_upg

239:
240: select /*+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4) */
241: status
242: into l_bcolu_status
243: from bom_cto_order_lines_upg
244: where line_id = v_all_configs.line_id ;
245:
246: WriteToLog('Line is in status :: '||l_bcolu_status, 2);
247:

Line 274: update /+ INDEX (BCOLU1 BOM_CTO_ORDER_LINES_UPG_N4) /

270: -- Here, we want to skip processing for
271: -- the rest of this ato_line_id, but continue
272: -- processing the remaining ato_line_ids.
273: --
274: update /*+ INDEX (BCOLU1 BOM_CTO_ORDER_LINES_UPG_N4) */
275: bom_cto_order_lines_upg bcolu1
276: set bcolu1.status = 'ERROR'
277: where bcolu1.ato_line_id =
278: (select bcolu2.ato_line_id

Line 275: bom_cto_order_lines_upg bcolu1

271: -- the rest of this ato_line_id, but continue
272: -- processing the remaining ato_line_ids.
273: --
274: update /*+ INDEX (BCOLU1 BOM_CTO_ORDER_LINES_UPG_N4) */
275: bom_cto_order_lines_upg bcolu1
276: set bcolu1.status = 'ERROR'
277: where bcolu1.ato_line_id =
278: (select bcolu2.ato_line_id
279: from bom_cto_order_lines_upg bcolu2

Line 279: from bom_cto_order_lines_upg bcolu2

275: bom_cto_order_lines_upg bcolu1
276: set bcolu1.status = 'ERROR'
277: where bcolu1.ato_line_id =
278: (select bcolu2.ato_line_id
279: from bom_cto_order_lines_upg bcolu2
280: where bcolu2.line_id = v_all_configs.line_id);
281:
282: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
283: l_error_flag := 'Y';

Line 320: update bom_cto_order_lines_upg bcolu

316: END IF; /* line on hold */
317: END LOOP;
318:
319: l_stmt_num := 60;
320: update bom_cto_order_lines_upg bcolu
321: set status = 'BOM_LOOP'
322: where sequence = p_seq
323: and status = 'BOM_PROC';
324:

Line 348: update bom_cto_order_lines_upg bcolu

344:
345: --
346: -- Update rows processed to BOM_BULK
347: --
348: update bom_cto_order_lines_upg bcolu
349: set status = 'BOM_BULK'
350: where bcolu.ato_line_id in (select ato_line_id
351: from bom_cto_order_lines_upg bcolu2
352: where bcolu2.sequence = p_seq

Line 351: from bom_cto_order_lines_upg bcolu2

347: --
348: update bom_cto_order_lines_upg bcolu
349: set status = 'BOM_BULK'
350: where bcolu.ato_line_id in (select ato_line_id
351: from bom_cto_order_lines_upg bcolu2
352: where bcolu2.sequence = p_seq
353: and bcolu2.status = 'BOM_LOOP');
354:
355: WriteToLog('Rows updated to status BOM_BULK::' ||sql%rowcount, 2);

Line 382: from bom_cto_order_lines_upg

378: /*delete from mrp_sr_assignments
379: where assignment_set_id = l_mrp_aset_id
380: and inventory_item_id in
381: (select config_item_id
382: from bom_cto_order_lines_upg
383: where sequence = p_seq
384: and status = 'BOM_BULK'
385: and (p_changed_src = 'Y'
386: or (p_changed_src = 'N' and nvl(config_creation,'1') = '3')));*/

Line 393: from bom_cto_order_lines_upg bcol

389: delete from mrp_sr_assignments msa
390: where msa.assignment_set_id = l_mrp_aset_id
391: and msa.inventory_item_id in
392: (select config_item_id
393: from bom_cto_order_lines_upg bcol
394: where sequence = p_seq
395: and status = 'BOM_BULK'
396: and bcol.config_item_id is not null
397: and EXISTS ( SELECT 'exists'

Line 413: from bom_cto_order_lines_upg bcol

409: delete from mrp_sr_assignments msa
410: where msa.assignment_set_id = l_mrp_aset_id
411: and msa.inventory_item_id in
412: ( select config_item_id
413: from bom_cto_order_lines_upg bcol
414: where sequence = p_seq
415: and status = 'BOM_BULK'
416: and bcol.config_item_id IS NOT null
417: and NOT EXISTS ( SELECT 'cto assg exists for config'

Line 512: from bom_cto_order_lines_upg bcolu

508: from mrp_sr_assignments ma
509: where ma.assignment_set_id = l_cto_aset_id
510: and ma.inventory_item_id in (
511: select distinct bcolu.config_item_id
512: from bom_cto_order_lines_upg bcolu
513: where bcolu.sequence = p_seq
514: and bcolu.status = 'BOM_BULK');
515:
516: WriteToLog('Rows inserted into MRP Default Assignment Set::' ||sql%rowcount, 2);

Line 521: update bom_cto_order_lines_upg

517:
518: --
519: -- update status to 'MRP_SRC'
520: --
521: update bom_cto_order_lines_upg
522: set status = 'MRP_SRC'
523: where sequence = p_seq
524: and status = 'BOM_BULK';
525:

Line 621: bom_cto_order_lines_upg bcolu

617: bcso.create_bom bom_create,
618: bcso.model_item_id,
619: bcso.config_item_id
620: from bom_cto_src_orgs bcso,
621: bom_cto_order_lines_upg bcolu
622: where bcso.line_id = pLineId
623: and bcso.model_item_id = pModelId
624: and bcso.config_item_id is not null
625: and bcso.line_id = bcolu.line_id ;

Line 642: from bom_cto_order_lines_upg

638: -- Get total lead time for this config based on OE validation org
639: --
640: select nvl(schedule_ship_date,sysdate), nvl(program_id, 0)
641: into g_SchShpDate, l_program_id
642: from bom_cto_order_lines_upg
643: where line_id = pLineId ;
644:
645: g_SchShpDate := greatest(g_SchShpDate, sysdate);
646: WriteToLog('Schedule Ship Date is '||g_SchShpDate, 4);

Line 672: FROM mtl_parameters mp, bom_cto_order_lines_upg bcol

668: exception
669: when no_data_found then
670: SELECT master_organization_id
671: INTO lOEValidationOrg
672: FROM mtl_parameters mp, bom_cto_order_lines_upg bcol
673: WHERE bcol.ship_from_org_id = mp.organization_id
674: and bcol.line_id = pLineid;
675: end; --Bugfix 6376208: The main query will run into no data found if SO having line_id has been purged.
676:

Line 693: from bom_cto_order_lines_upg bcolu

689: bcolu.inventory_item_id,
690: bcolu.parent_ato_line_id,
691: bcolu.ordered_quantity
692: into lLineId, lModelId, lParentAtoLineId, lOrderedQty
693: from bom_cto_order_lines_upg bcolu
694: where bcolu.line_id = lParentAtoLineId;
695:
696: WriteToLog('lLineId: ' || to_char(lLineId), 5);
697: WriteToLog('lModelId: ' || to_char(lModelId), 5);

Line 912: from bom_cto_order_lines_upg

908: cursor missed_lines ( xlineid number,
909: xconfigbillid number,
910: xEstRelDate date ) is /* Effectivity_date changes */
911: select line_id
912: from bom_cto_order_lines_upg
913: where parent_ato_line_id=xlineid
914: and parent_ato_line_id <> line_id /* to avoid selecting top model */
915: minus
916: select revised_item_sequence_id /* new column used to store line_id */

Line 1017: v_program_id bom_cto_order_lines_upg.program_id%type;

1013: --where last_update_login=pRtgId;
1014: where config_routing_id=pRtgId;
1015:
1016:
1017: v_program_id bom_cto_order_lines_upg.program_id%type;
1018:
1019: TYPE mod_opclass_rtg_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1020:
1021:

Line 1045: from bom_cto_order_lines_upg bcolu,

1041: select oel.line_id,
1042: oel.header_id header_id,
1043: oeh.order_number order_num,
1044: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number)) line_num
1045: from bom_cto_order_lines_upg bcolu,
1046: oe_order_lines_all oel,
1047: oe_order_headers_all oeh
1048: where bcolu.config_item_id = pConfigId
1049: and nvl(bcolu.program_id, -99) <> 99

Line 1211: bom_cto_order_lines_upg bcolu,

1207: select CAL.CALENDAR_DATE
1208: into lEstRelDate
1209: from bom_calendar_dates cal,
1210: mtl_system_items msi,
1211: bom_cto_order_lines_upg bcolu,
1212: mtl_parameters mp
1213: where msi.organization_id = pOrgId
1214: and msi.inventory_item_id = pModelId
1215: and bcolu.line_id = pLineId

Line 1425: bom_cto_order_lines_upg bcol1, -- Option

1421: , nvl(ic1.basis_type,1), /* LBM project */
1422: cto_msutil_pub.bom_batch_id
1423: from
1424: bom_inventory_components ic1,
1425: bom_cto_order_lines_upg bcol1, -- Option
1426: bom_cto_order_lines_upg bcol2, -- Parent-Model
1427: bom_cto_order_lines_upg bcol3, -- Parent-component
1428: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1429: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881

Line 1426: bom_cto_order_lines_upg bcol2, -- Parent-Model

1422: cto_msutil_pub.bom_batch_id
1423: from
1424: bom_inventory_components ic1,
1425: bom_cto_order_lines_upg bcol1, -- Option
1426: bom_cto_order_lines_upg bcol2, -- Parent-Model
1427: bom_cto_order_lines_upg bcol3, -- Parent-component
1428: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1429: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1430: where ic1.bill_sequence_id = (

Line 1427: bom_cto_order_lines_upg bcol3, -- Parent-component

1423: from
1424: bom_inventory_components ic1,
1425: bom_cto_order_lines_upg bcol1, -- Option
1426: bom_cto_order_lines_upg bcol2, -- Parent-Model
1427: bom_cto_order_lines_upg bcol3, -- Parent-component
1428: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1429: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1430: where ic1.bill_sequence_id = (
1431: select common_bill_sequence_id

Line 1667: bom_cto_order_lines_upg bcol1, -- component

1663: bcol1.plan_level+1-bcol2.plan_level --plan_level
1664: , nvl(ic1.basis_type,1), /* LBM project */
1665: cto_msutil_pub.bom_batch_id
1666: from
1667: bom_cto_order_lines_upg bcol1, -- component
1668: bom_cto_order_lines_upg bcol2, -- Model
1669: mtl_system_items si1,
1670: mtl_system_items si2,
1671: bom_bill_of_materials b,

Line 1668: bom_cto_order_lines_upg bcol2, -- Model

1664: , nvl(ic1.basis_type,1), /* LBM project */
1665: cto_msutil_pub.bom_batch_id
1666: from
1667: bom_cto_order_lines_upg bcol1, -- component
1668: bom_cto_order_lines_upg bcol2, -- Model
1669: mtl_system_items si1,
1670: mtl_system_items si2,
1671: bom_bill_of_materials b,
1672: bom_inventory_components ic1

Line 1878: from bom_cto_order_lines_upg

1874: select ship_from_org_id,
1875: inventory_item_id
1876: into ship_org_id_temp,
1877: item_id_temp
1878: from bom_cto_order_lines_upg
1879: where line_id = v_missed_line_id;
1880:
1881: oe_debug_pub.add('New Msg: ship_org_id_temp:' || ship_org_id_temp);
1882: oe_debug_pub.add('New Msg: item_id_temp:' || item_id_temp);

Line 1893: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu

1889: /*select substrb(msi.concatenated_segments,1,50),
1890: 'Not Available' ,
1891: -1
1892: into v_missed_item,v_missed_line_number,v_order_number
1893: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu
1894: where msi.organization_id = bcolu.ship_from_org_id
1895: and msi.inventory_item_id = bcolu.inventory_item_id
1896: and bcolu.line_id = v_missed_line_id;
1897: */

Line 1904: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu

1900: select substrb(msi.concatenated_segments,1,50),
1901: 'Not Available' ,
1902: -1
1903: into v_missed_item,v_missed_line_number,v_order_number
1904: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu
1905: where msi.inventory_item_id = bcolu.inventory_item_id
1906: and bcolu.line_id = v_missed_line_id
1907: and rownum = 1;
1908: --End Bugfix 10240482

Line 1978: from bom_cto_order_lines_upg

1974: -- Put all open order lines having this config item on hold
1975: --
1976: select nvl(config_creation, '1')
1977: into l_config_creation
1978: from bom_cto_order_lines_upg
1979: where line_id = pLineId;
1980:
1981: WriteToLog('l_config_creation:: '||l_config_creation, 3);
1982:

Line 2073: from bom_cto_order_lines_upg bcolu,

2069: into l_hold_source_rec.line_id,
2070: l_hold_source_rec.header_id,
2071: l_order_num,
2072: l_line_number
2073: from bom_cto_order_lines_upg bcolu,
2074: oe_order_lines_all oel,
2075: oe_order_headers_all oeh
2076: where bcolu.line_id = pLineId
2077: and bcolu.ato_line_id = oel.ato_line_id /* BUG 3396081 dropped component in lower config */

Line 2179: update bom_cto_order_lines_upg bcolu1

2175: -- Update status to 'ERROR'
2176: -- Update for all lines having this config if config creation = 3
2177: --
2178: IF l_config_creation = 3 THEN
2179: update bom_cto_order_lines_upg bcolu1
2180: set bcolu1.status = 'ERROR'
2181: where bcolu1.ato_line_id in
2182: (select bcolu2.ato_line_id
2183: from bom_cto_order_lines_upg bcolu2

Line 2183: from bom_cto_order_lines_upg bcolu2

2179: update bom_cto_order_lines_upg bcolu1
2180: set bcolu1.status = 'ERROR'
2181: where bcolu1.ato_line_id in
2182: (select bcolu2.ato_line_id
2183: from bom_cto_order_lines_upg bcolu2
2184: where config_item_id = pConfigId);
2185:
2186: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
2187: ELSE

Line 2188: update bom_cto_order_lines_upg bcolu1

2184: where config_item_id = pConfigId);
2185:
2186: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
2187: ELSE
2188: update bom_cto_order_lines_upg bcolu1
2189: set bcolu1.status = 'ERROR'
2190: where bcolu1.ato_line_id =
2191: (select bcolu2.ato_line_id
2192: from bom_cto_order_lines_upg bcolu2

Line 2192: from bom_cto_order_lines_upg bcolu2

2188: update bom_cto_order_lines_upg bcolu1
2189: set bcolu1.status = 'ERROR'
2190: where bcolu1.ato_line_id =
2191: (select bcolu2.ato_line_id
2192: from bom_cto_order_lines_upg bcolu2
2193: where bcolu2.line_id = pLineId);
2194:
2195: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
2196: END IF;

Line 2342: bom_cto_order_lines_upg bcol

2338: 0 --plan_level
2339: , 1, -- basis_type /* LBM project */
2340: cto_msutil_pub.bom_batch_id
2341: from
2342: bom_cto_order_lines_upg bcol
2343: where bcol.line_id = pLineId
2344: and bcol.ordered_quantity <> 0
2345: and bcol.inventory_item_id = pModelId;
2346:

Line 2552: bom_cto_order_lines_upg bcol1,

2548: nvl(operation_type,1),
2549: os1.routing_sequence_id,
2550: l_batch_id
2551: from
2552: bom_cto_order_lines_upg bcol1,
2553: mtl_system_items si1,
2554: bom_operational_routings or1,
2555: bom_operation_sequences os1
2556: where bcol1.line_id = pLineId

Line 2585: bom_cto_order_lines_upg bcol1, -- components

2581: NVL(os1.operation_type,1),
2582: os1.routing_sequence_id,
2583: l_batch_id
2584: from
2585: bom_cto_order_lines_upg bcol1, -- components
2586: bom_cto_order_lines_upg bcol2, -- parent models or option classes
2587: mtl_system_items msi,
2588: bom_inventory_components ic1,
2589: bom_bill_of_materials b1,

Line 2586: bom_cto_order_lines_upg bcol2, -- parent models or option classes

2582: os1.routing_sequence_id,
2583: l_batch_id
2584: from
2585: bom_cto_order_lines_upg bcol1, -- components
2586: bom_cto_order_lines_upg bcol2, -- parent models or option classes
2587: mtl_system_items msi,
2588: bom_inventory_components ic1,
2589: bom_bill_of_materials b1,
2590: bom_operational_routings or1,

Line 2977: bom_cto_order_lines_upg bcol,

2973: nvl(os1.operation_type,1),
2974: os1.routing_sequence_id
2975: from
2976: mtl_system_items si1,
2977: bom_cto_order_lines_upg bcol,
2978: bom_operational_routings or1,
2979: bom_operation_sequences os1
2980: where bcol.parent_ato_line_id = pLineId
2981: and si1.organization_id = pOrgId

Line 3006: bom_cto_order_lines_upg bcol1, /* components */

3002: os1.operation_seq_num,
3003: nvl(os1.operation_type,1),
3004: os1.routing_sequence_id
3005: from
3006: bom_cto_order_lines_upg bcol1, /* components */
3007: bom_cto_order_lines_upg bcol2, /* parents model */
3008: bom_inventory_components ic1,
3009: bom_bill_of_materials b1,
3010: bom_operational_routings or1,

Line 3007: bom_cto_order_lines_upg bcol2, /* parents model */

3003: nvl(os1.operation_type,1),
3004: os1.routing_sequence_id
3005: from
3006: bom_cto_order_lines_upg bcol1, /* components */
3007: bom_cto_order_lines_upg bcol2, /* parents model */
3008: bom_inventory_components ic1,
3009: bom_bill_of_materials b1,
3010: bom_operational_routings or1,
3011: bom_operation_sequences os1

Line 3073: bom_cto_order_lines_upg bcol /* Model or option class */

3069: mtl_system_items si2,
3070: bom_inventory_components ic1,
3071: bom_bill_of_materials b1,
3072: mtl_system_items si1,
3073: bom_cto_order_lines_upg bcol /* Model or option class */
3074: where bcol.parent_ato_line_id = pLineId
3075: and bcol.component_sequence_id is not null
3076: and bcol.ordered_quantity <> 0
3077: and si1.organization_id = pOrgId

Line 5409: bom_cto_order_lines_upg bcolu

5405: NULL, /* ATTRIBUTE14 */
5406: NULL /* ATTRIBUTE15 */
5407: from bom_operational_routings bor,
5408: mtl_parameters mp,
5409: bom_cto_order_lines_upg bcolu
5410: where bcolu.sequence = p_seq
5411: and bcolu.status = 'BOM_LOOP'
5412: and bcolu.config_item_id = bor.assembly_item_id
5413: and bor.alternate_routing_designator is null

Line 5521: bom_cto_order_lines_upg bcolu,

5517: bor.principle_flag
5518: from
5519: bom_operation_sequences osi,
5520: bom_operation_resources bor,
5521: bom_cto_order_lines_upg bcolu,
5522: bom_operational_routings bor1
5523: where bcolu.sequence = p_seq
5524: and bcolu.status = 'BOM_LOOP'
5525: and bcolu.config_item_id = bor1.assembly_item_id

Line 5639: bom_cto_order_lines_upg bcolu,

5635: NULL /*program_update_date*/
5636: from
5637: bom_operation_sequences osi,
5638: bom_sub_operation_resources bsor,
5639: bom_cto_order_lines_upg bcolu,
5640: bom_operational_routings bor
5641: where bcolu.sequence = p_seq
5642: and bcolu.status = 'BOM_LOOP'
5643: and bcolu.config_item_id = bor.assembly_item_id

Line 5728: bom_cto_order_lines_upg bcolu

5724: bom_operation_sequences bos2, /* 'to' Ops of model */
5725: bom_operation_sequences bos3, /* 'from' Ops of config */
5726: bom_operation_sequences bos4, /* 'to' Ops of config */
5727: bom_operational_routings brif,
5728: bom_cto_order_lines_upg bcolu
5729: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
5730: AND bon.to_op_seq_id = bos2.operation_sequence_id
5731: AND bos1.routing_sequence_id = bos2.routing_sequence_id
5732: AND bos3.routing_sequence_id = brif.routing_sequence_id

Line 5875: xLineId bom_cto_order_lines_upg.line_id%TYPE,

5871: xMessageName out NOCOPY VARCHAR2)
5872: RETURN INTEGER IS
5873:
5874: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
5875: xLineId bom_cto_order_lines_upg.line_id%TYPE,
5876: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
5877: xSchShpdt date,
5878: xEstReldt date ) IS
5879: select bbm.organization_id,

Line 5923: from bom_cto_order_lines_upg bcol1, -- COMPONENT

5919: bic.effectivity_date ,
5920: sysdate ) eff_date,
5921: nvl(bic.disable_date,g_futuredate) dis_date, -- 3222932 /* 02-14-2005 Sushant */
5922: nvl(bic.basis_type,1) basis_type
5923: from bom_cto_order_lines_upg bcol1, -- COMPONENT
5924: bom_cto_order_lines_upg bcol2, -- MODEL
5925: mtl_system_items si1,
5926: mtl_system_items si2,
5927: bom_bill_of_materials bbm,

Line 5924: bom_cto_order_lines_upg bcol2, -- MODEL

5920: sysdate ) eff_date,
5921: nvl(bic.disable_date,g_futuredate) dis_date, -- 3222932 /* 02-14-2005 Sushant */
5922: nvl(bic.basis_type,1) basis_type
5923: from bom_cto_order_lines_upg bcol1, -- COMPONENT
5924: bom_cto_order_lines_upg bcol2, -- MODEL
5925: mtl_system_items si1,
5926: mtl_system_items si2,
5927: bom_bill_of_materials bbm,
5928: bom_inventory_components bic, -- Components

Line 6132: bom_cto_order_lines_upg bcol1,

6128: nvl(ic1.disable_date,g_futuredate),
6129: bcol3.inventory_item_id , /* Bug Fix: 4147224 */
6130: nvl(ic1.basis_type,1)
6131: from bom_inventory_components ic1,
6132: bom_cto_order_lines_upg bcol1,
6133: bom_cto_order_lines_upg bcol2,
6134: bom_cto_order_lines_upg bcol3,
6135: mtl_system_items msi_child,
6136: mtl_system_items msi_parent

Line 6133: bom_cto_order_lines_upg bcol2,

6129: bcol3.inventory_item_id , /* Bug Fix: 4147224 */
6130: nvl(ic1.basis_type,1)
6131: from bom_inventory_components ic1,
6132: bom_cto_order_lines_upg bcol1,
6133: bom_cto_order_lines_upg bcol2,
6134: bom_cto_order_lines_upg bcol3,
6135: mtl_system_items msi_child,
6136: mtl_system_items msi_parent
6137: where ic1.bill_sequence_id = (

Line 6134: bom_cto_order_lines_upg bcol3,

6130: nvl(ic1.basis_type,1)
6131: from bom_inventory_components ic1,
6132: bom_cto_order_lines_upg bcol1,
6133: bom_cto_order_lines_upg bcol2,
6134: bom_cto_order_lines_upg bcol3,
6135: mtl_system_items msi_child,
6136: mtl_system_items msi_parent
6137: where ic1.bill_sequence_id = (
6138: select common_bill_sequence_id

Line 6332: from bom_cto_order_lines_upg bcol,

6328: bic.effectivity_date ,
6329: sysdate ),
6330: nvl(bic.disable_date,g_futuredate) -- 3222932
6331: , nvl(bic.basis_type,1) /* LBM project */
6332: from bom_cto_order_lines_upg bcol,
6333: bom_bill_of_materials bbm,
6334: bom_inventory_components bic
6335: where bcol.line_id = pLineId
6336: and bcol.ordered_quantity <> 0