DBA Data[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on PA_TASKS

Line 261: PA_PROJECTS bom_hdr_pp, PA_TASKS bom_hdr_pt

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, '@@@')
265: AND bom_hdr.project_id = bom_hdr_pp.project_id(+)

Line 329: PA_PROJECTS bom_rte_pp, PA_TASKS bom_rte_pt,

325: bom_rte.total_product_cycle_time,
326: bom_rte_pp.name project_name,
327: bom_rte_pt.task_name
328: FROM BOM_OPERATIONAL_ROUTINGS bom_rte,
329: PA_PROJECTS bom_rte_pp, PA_TASKS bom_rte_pt,
330: WIP_LINES bom_rte_wl
331: WHERE bom_rte.assembly_item_id = p_inventory_item_id
332: AND bom_rte.organization_id = p_organization_id
333: AND nvl(bom_rte.alternate_routing_designator, '@@@') = nvl(p_alternate_routing_designator, '@@@')