APPS.INV_LABEL_PVT10 dependencies on BOM_BILL_OF_MATERIALS

Line 232: p_inventory_item_id bom_bill_of_materials.assembly_item_id%TYPE,

228: END get_data ;
229: /*=================================================================*/
230: PROCEDURE get_data_bom_bill_header(
231: x_out_tbl IN OUT NOCOPY output_tbl_type,
232: p_inventory_item_id bom_bill_of_materials.assembly_item_id%TYPE,
233: p_organization_id bom_bill_of_materials.organization_id%TYPE,
234: p_alternate_bom_designator bom_bill_of_materials.alternate_bom_designator%TYPE
235: )IS
236:

Line 233: p_organization_id bom_bill_of_materials.organization_id%TYPE,

229: /*=================================================================*/
230: PROCEDURE get_data_bom_bill_header(
231: x_out_tbl IN OUT NOCOPY output_tbl_type,
232: p_inventory_item_id bom_bill_of_materials.assembly_item_id%TYPE,
233: p_organization_id bom_bill_of_materials.organization_id%TYPE,
234: p_alternate_bom_designator bom_bill_of_materials.alternate_bom_designator%TYPE
235: )IS
236:
237: CURSOR bom_header_curs IS

Line 234: p_alternate_bom_designator bom_bill_of_materials.alternate_bom_designator%TYPE

230: PROCEDURE get_data_bom_bill_header(
231: x_out_tbl IN OUT NOCOPY output_tbl_type,
232: p_inventory_item_id bom_bill_of_materials.assembly_item_id%TYPE,
233: p_organization_id bom_bill_of_materials.organization_id%TYPE,
234: p_alternate_bom_designator bom_bill_of_materials.alternate_bom_designator%TYPE
235: )IS
236:
237: CURSOR bom_header_curs IS
238: SELECT

Line 260: FROM BOM_BILL_OF_MATERIALS bom_hdr,

256: bom_hdr.attribute_category,
257: bom_hdr_pp.name project_name,
258: bom_hdr_pt.task_name task_name,
259: Bom_hdr.specific_assembly_comment
260: FROM BOM_BILL_OF_MATERIALS bom_hdr,
261: PA_PROJECTS bom_hdr_pp, PA_TASKS bom_hdr_pt
262: WHERE bom_hdr.assembly_item_id = p_inventory_item_id
263: AND bom_hdr.organization_id = p_organization_id
264: AND nvl(bom_hdr.alternate_bom_designator, '@@@') = nvl(p_alternate_bom_designator, '@@@')