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_ALL

Line 3043: , po_distributions_all pda

3039: , (pda.quantity_ordered - pda.quantity_delivered)
3040: , woov.repetitive_schedule_id
3041: FROM po_headers_all phl
3042: , po_lines_all pla
3043: , po_distributions_all pda
3044: , po_releases_all prl
3045: , wip_osp_jobs_val_v wojv
3046: , wip_osp_lines_val_v wolv
3047: , wip_osp_operations_val_v woov

Line 3081: , po_distributions_all pda

3077: , (pda.quantity_ordered - pda.quantity_delivered)
3078: , woov.repetitive_schedule_id
3079: FROM po_headers_all phl
3080: , po_lines_all pla
3081: , po_distributions_all pda
3082: , wip_osp_jobs_val_v wojv
3083: , wip_osp_lines_val_v wolv
3084: , wip_osp_operations_val_v woov
3085: WHERE phl.po_header_id = p_po_header_id

Line 3317: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID

3313: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3314: )
3315: -- End for Bug 7440217
3316: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3317: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID
3318: and pd.po_line_id = pol.po_line_id
3319: and pd.po_release_id = p_poReleaseID
3320: and ((p_projectId is null or pd.project_id = p_projectId)
3321: and (p_taskId is null or pd.task_id = p_taskId)

Line 3411: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID

3407: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3408: )
3409: -- End for Bug 7440217
3410: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3411: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID
3412: and pd.po_line_id = pol.po_line_id
3413: and pd.po_release_id = p_poReleaseID
3414: and ((p_projectId is null or pd.project_id = p_projectId)
3415: and (p_taskId is null or pd.task_id = p_taskId)

Line 3499: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID

3495: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3496: )
3497: -- End for Bug 7440217
3498: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3499: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID
3500: and pd.po_line_id = pol.po_line_id
3501: and pd.po_release_id = p_poReleaseID
3502: and ((p_projectId is null or pd.project_id = p_projectId)
3503: and (p_taskId is null or pd.task_id = p_taskId)

Line 3569: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID

3565: and pol.ITEM_ID is null
3566: and pol.item_description is not null
3567: and pol.po_header_id = p_poHeaderID
3568: and pol.item_description like p_concatenated_segments
3569: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID
3570: and pd.po_line_id = pol.po_line_id
3571: and pd.po_release_id = p_poReleaseID
3572: and ((p_projectId is null or pd.project_id = p_projectId)
3573: and (p_taskId is null or pd.task_id = p_taskId)

Line 3687: and exists (select 1 from po_distributions_all pd where pd.po_header_id =

3683: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3684: )
3685: -- End for Bug 7440217
3686: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3687: and exists (select 1 from po_distributions_all pd where pd.po_header_id =
3688: p_poHeaderID
3689: and pd.po_line_id = pol.po_line_id
3690: and pd.po_release_id = p_poReleaseID
3691: and ((p_projectId is null or pd.project_id = p_projectId)

Line 3777: and exists (select 1 from po_distributions_all pd

3773: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3774: )
3775: -- End for Bug 7440217
3776: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3777: and exists (select 1 from po_distributions_all pd
3778: where pd.po_header_id = p_poHeaderID
3779: and pd.po_line_id = p_poLineID
3780: and pd.po_line_id = pol.po_line_id
3781: and ((p_projectId is null or pd.project_id = p_projectId)

Line 3872: and exists ( select 1 from po_distributions_all pd

3868: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3869: )
3870: -- End for Bug 7440217
3871: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3872: and exists ( select 1 from po_distributions_all pd
3873: where pd.po_header_id = p_poHeaderID
3874: and pd.po_line_id = p_poLineID
3875: and pd.po_line_id = pol.po_line_id
3876: and ((p_projectId is null or pd.project_id = p_projectId)

Line 3961: and exists (select 1 from po_distributions_all pd

3957: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
3958: )
3959: -- End for Bug 7440217
3960: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
3961: and exists (select 1 from po_distributions_all pd
3962: where pd.po_header_id = p_poHeaderID
3963: and pd.po_line_id = pol.po_line_id
3964: and pd.po_line_id = p_poLineID
3965: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4032: and exists ( select 1 from po_distributions_all pd

4028: and pol.ITEM_ID is null
4029: and pol.item_description is not null
4030: and pol.po_header_id = p_poHeaderID
4031: and pol.item_description like p_concatenated_segments
4032: and exists ( select 1 from po_distributions_all pd
4033: where pd.po_header_id = p_poHeaderID
4034: and pd.po_line_id = p_poLineID
4035: and pd.po_line_id = pol.po_line_id
4036: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4151: and exists (select 1 from po_distributions_all pd

4147: OR (NVL(pll.lcm_flag,'N') = 'N') -- Org is lcm enabled, pre-receiving and non-lcm enabled shipment
4148: )
4149: -- End for Bug 7440217
4150: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4151: and exists (select 1 from po_distributions_all pd
4152: where pd.po_header_id = p_poHeaderID
4153: and pd.po_line_id = pol.po_line_id
4154: and pd.po_line_id = p_poLineID
4155: and ((p_projectId is null or pd.project_id = p_projectId)

Line 4250: (select 1 from po_distributions_all pd

4246: )
4247: -- End for Bug 7440217
4248: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4249: and exists
4250: (select 1 from po_distributions_all pd
4251: where pd.po_header_id = p_poHeaderID
4252: and pd.po_line_id = pol.po_line_id
4253: and ((p_projectId is null or pd.project_id = p_projectId)
4254: and (p_taskId is null or pd.task_id = p_taskId)

Line 4343: (select 1 from po_distributions_all pd

4339: )
4340: -- End for Bug 7440217
4341: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4342: and exists
4343: (select 1 from po_distributions_all pd
4344: where pd.po_header_id = p_poHeaderID
4345: and pd.po_line_id = pol.po_line_id
4346: and ((p_projectId is null or pd.project_id = p_projectId)
4347: and (p_taskId is null or pd.task_id = p_taskId)

Line 4432: (select 1 from po_distributions_all pd

4428: )
4429: -- End for Bug 7440217
4430: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4431: and exists
4432: (select 1 from po_distributions_all pd
4433: where pd.po_header_id = p_poHeaderID
4434: and pd.po_line_id = pol.po_line_id
4435: and ((p_projectId is null or pd.project_id = p_projectId)
4436: and (p_taskId is null or pd.task_id = p_taskId)

Line 4503: (select 1 from po_distributions_all pd

4499: and pol.item_description is not null
4500: and pol.po_header_id = p_poHeaderID
4501: and pol.item_description like p_concatenated_segments
4502: and exists
4503: (select 1 from po_distributions_all pd
4504: where pd.po_header_id = p_poHeaderID
4505: and pd.po_line_id = pol.po_line_id
4506: and ((p_projectId is null or pd.project_id = p_projectId)
4507: and (p_taskId is null or pd.task_id = p_taskId)

Line 4621: from po_distributions_all pd

4617: )
4618: -- End for Bug 7440217
4619: )--Bug 3972931-Added the filter condition based on ship_to_organization_id
4620: and exists (select 1
4621: from po_distributions_all pd
4622: where pd.po_header_id = p_poHeaderID
4623: and pd.po_line_id = pol.po_line_id
4624: and ((p_projectId is null or pd.project_id = p_projectId)
4625: and (p_taskId is null or pd.task_id = p_taskId)