APPS.CTO_UPDATE_BOM_RTG_PK dependencies on OE_ORDER_LINES

Line 608: from oe_order_lines_all oel

604: begin
605: /* BUGFIX# 3484511 */
606: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
607: into lOEValidationOrg
608: from oe_order_lines_all oel
609: where oel.line_id = pLineid ;
610:
611: exception
612: when no_data_found then

Line 987: oe_order_lines_all oel,

983: oel.header_id header_id,
984: oeh.order_number order_num,
985: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number)) line_num
986: from bom_cto_order_lines_upg bcolu,
987: oe_order_lines_all oel,
988: oe_order_headers_all oeh
989: where bcolu.config_item_id = pConfigId
990: and nvl(bcolu.program_id, -99) <> 99
991: and bcolu.line_id = oel.ato_line_id

Line 1794: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh

1790: select substrb(msi.concatenated_segments,1,50),
1791: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(option_number)),
1792: oeh.order_number
1793: into v_missed_item,v_missed_line_number,v_order_number
1794: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1795: where msi.organization_id = oel.ship_from_org_id
1796: and msi.inventory_item_id = oel.inventory_item_id
1797: and oel.header_id = oeh.header_id
1798: and oel.line_id = v_missed_line_id;

Line 1985: oe_order_lines_all oel,

1981: l_hold_source_rec.header_id,
1982: l_order_num,
1983: l_line_number
1984: from bom_cto_order_lines_upg bcolu,
1985: oe_order_lines_all oel,
1986: oe_order_headers_all oeh
1987: where bcolu.line_id = pLineId
1988: and bcolu.ato_line_id = oel.ato_line_id /* BUG 3396081 dropped component in lower config */
1989: and oel.item_type_code = 'CONFIG'

Line 5657: pLineId in oe_order_lines.line_id%TYPE := NULL,

5653: END update_item_num;
5654:
5655:
5656: FUNCTION inherit_op_seq_ml(
5657: pLineId in oe_order_lines.line_id%TYPE := NULL,
5658: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
5659: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
5660: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
5661: xErrorMessage out NOCOPY VARCHAR2,

Line 5658: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,

5654:
5655:
5656: FUNCTION inherit_op_seq_ml(
5657: pLineId in oe_order_lines.line_id%TYPE := NULL,
5658: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
5659: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
5660: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
5661: xErrorMessage out NOCOPY VARCHAR2,
5662: xMessageName out NOCOPY VARCHAR2)