APPS.INV_LABEL_PVT10 dependencies on PA_PROJECTS

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, '@@@')

Line 1173: PA_PROJECTS pp,

1169: ) shiptoc,
1170: --
1171: -- Modification End for Bug # - 4418524
1172: --
1173: PA_PROJECTS pp,
1174: --ORG_FREIGHT_VL ofv,
1175: RA_SALESREPS ras,
1176: OE_SETS,
1177: AR_LOOKUPS,

Line 1687: PA_PROJECTS pp,

1683: AND REL.object_table_name = 'HZ_PARTIES'
1684: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1685: AND ROLE_ACCT.party_id = REL.object_id
1686: ) invc,
1687: PA_PROJECTS pp,
1688: --ORG_FREIGHT_VL ofv,
1689: RA_SALESREPS ras,
1690: OE_SETS,
1691: AR_LOOKUPS,