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.INV_UI_RCV_LOVS dependencies on PO_DISTRIBUTIONS_TRX_V

Line 3458: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

3454: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3455: )
3456: -- End for Bug 7440217
3457: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3458: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
3459: where pd.po_header_id = p_poHeaderID
3460: and pd.po_line_id = pol.po_line_id
3461: and pd.po_release_id = p_poReleaseID
3462: and ((p_projectId is null or pd.project_id = p_projectId)

Line 3556: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

3552: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3553: )
3554: -- End for Bug 7440217
3555: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3556: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
3557: where pd.po_header_id = p_poHeaderID
3558: and pd.po_line_id = pol.po_line_id
3559: and pd.po_release_id = p_poReleaseID
3560: and ((p_projectId is null or pd.project_id = p_projectId)

Line 3648: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

3644: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3645: )
3646: -- End for Bug 7440217
3647: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3648: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
3649: where pd.po_header_id = p_poHeaderID
3650: and pd.po_line_id = pol.po_line_id
3651: and pd.po_release_id = p_poReleaseID
3652: and ((p_projectId is null or pd.project_id = p_projectId)

Line 3722: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

3718: and pol.ITEM_ID is null
3719: and pol.item_description is not null
3720: and pol.po_header_id = p_poHeaderID
3721: and pol.item_description like p_concatenated_segments
3722: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
3723: where pd.po_header_id = p_poHeaderID
3724: and pd.po_line_id = pol.po_line_id
3725: and pd.po_release_id = p_poReleaseID
3726: and ((p_projectId is null or pd.project_id = p_projectId)

Line 3845: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

3841: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3842: )
3843: -- End for Bug 7440217
3844: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3845: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
3846: where pd.po_header_id = p_poHeaderID
3847: and pd.po_line_id = pol.po_line_id
3848: and pd.po_release_id = p_poReleaseID
3849: and ((p_projectId is null or pd.project_id = p_projectId)

Line 3920: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

3916: and pol.ITEM_ID is null
3917: and pol.vendor_product_num is not null
3918: and pol.po_header_id = p_poHeaderID
3919: and pol.vendor_product_num like p_concatenated_segments
3920: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
3921: where pd.po_header_id = p_poHeaderID
3922: and pd.po_line_id = pol.po_line_id
3923: and pd.po_release_id = p_poReleaseID
3924: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4037: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4033: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
4034: )
4035: -- End for Bug 7440217
4036: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4037: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4038: where pd.po_header_id = p_poHeaderID
4039: and pd.po_line_id = p_poLineID
4040: and pd.po_line_id = pol.po_line_id
4041: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4135: and exists ( select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4131: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
4132: )
4133: -- End for Bug 7440217
4134: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4135: and exists ( select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4136: where pd.po_header_id = p_poHeaderID
4137: and pd.po_line_id = p_poLineID
4138: and pd.po_line_id = pol.po_line_id
4139: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4227: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4223: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
4224: )
4225: -- End for Bug 7440217
4226: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4227: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4228: where pd.po_header_id = p_poHeaderID
4229: and pd.po_line_id = pol.po_line_id
4230: and pd.po_line_id = p_poLineID
4231: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4301: and exists ( select 1 from po_distributions_trx_v pd

4297: and pol.ITEM_ID is null
4298: and pol.item_description is not null
4299: and pol.po_header_id = p_poHeaderID
4300: and pol.item_description like p_concatenated_segments
4301: and exists ( select 1 from po_distributions_trx_v pd
4302: where pd.po_header_id = p_poHeaderID
4303: and pd.po_line_id = p_poLineID
4304: and pd.po_line_id = pol.po_line_id
4305: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4423: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4419: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
4420: )
4421: -- End for Bug 7440217
4422: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4423: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4424: where pd.po_header_id = p_poHeaderID
4425: and pd.po_line_id = pol.po_line_id
4426: and pd.po_line_id = p_poLineID
4427: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4500: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4496: and pol.ITEM_ID is null
4497: and pol.vendor_product_num is not null
4498: and pol.po_header_id = p_poHeaderID
4499: and pol.vendor_product_num like p_concatenated_segments
4500: and exists (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4501: where pd.po_header_id = p_poHeaderID
4502: and pd.po_line_id = p_poLineID
4503: and pd.po_line_id = pol.po_line_id
4504: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4626: (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4622: )
4623: -- End for Bug 7440217
4624: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4625: and exists
4626: (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4627: where pd.po_header_id = p_poHeaderID
4628: and pd.po_line_id = pol.po_line_id
4629: and ((p_projectId is null or pd.project_id = p_projectId)
4630: and (p_taskId is null or pd.task_id = p_taskId)

Line 4722: (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4718: )
4719: -- End for Bug 7440217
4720: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4721: and exists
4722: (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4723: where pd.po_header_id = p_poHeaderID
4724: and pd.po_line_id = pol.po_line_id
4725: and ((p_projectId is null or pd.project_id = p_projectId)
4726: and (p_taskId is null or pd.task_id = p_taskId)

Line 4814: (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4810: )
4811: -- End for Bug 7440217
4812: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4813: and exists
4814: (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4815: where pd.po_header_id = p_poHeaderID
4816: and pd.po_line_id = pol.po_line_id
4817: and ((p_projectId is null or pd.project_id = p_projectId)
4818: and (p_taskId is null or pd.task_id = p_taskId)

Line 4888: (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291

4884: and pol.item_description is not null
4885: and pol.po_header_id = p_poHeaderID
4886: and pol.item_description like p_concatenated_segments
4887: and exists
4888: (select 1 from po_distributions_trx_v pd -- CLM project, bug 9403291
4889: where pd.po_header_id = p_poHeaderID
4890: and pd.po_line_id = pol.po_line_id
4891: and ((p_projectId is null or pd.project_id = p_projectId)
4892: and (p_taskId is null or pd.task_id = p_taskId)

Line 5009: from po_distributions_trx_v pd -- CLM project, bug 9403291

5005: )
5006: -- End for Bug 7440217
5007: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
5008: and exists (select 1
5009: from po_distributions_trx_v pd -- CLM project, bug 9403291
5010: where pd.po_header_id = p_poHeaderID
5011: and pd.po_line_id = pol.po_line_id
5012: and ((p_projectId is null or pd.project_id = p_projectId)
5013: and (p_taskId is null or pd.task_id = p_taskId)