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.GML_MOBILE_RECEIPT dependencies on PO_DISTRIBUTIONS_ALL

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

909: and pll.po_release_id = p_poReleaseID
910: and pll.po_line_id = pol.po_line_id
911: AND Nvl(pll.cancel_flag,'N') = 'N'
912: and pll.receiving_routing_id = 3)
913: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID
914: and pd.po_line_id = pol.po_line_id
915: and pd.po_release_id = p_poReleaseID
916: and ((p_projectId is null or pd.project_id = p_projectId)
917: and (p_taskId is null or pd.task_id = p_taskId)

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

970: and pll.po_line_id = pol.po_line_id
971: and pll.po_release_id = p_poReleaseID
972: AND Nvl(pll.cancel_flag,'N') = 'N'
973: and pll.receiving_routing_id = 3)
974: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID
975: and pd.po_line_id = pol.po_line_id
976: and pd.po_release_id = p_poReleaseID
977: and ((p_projectId is null or pd.project_id = p_projectId)
978: and (p_taskId is null or pd.task_id = p_taskId)

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

1024: and pll.po_release_id = p_poReleaseID
1025: and pll.po_line_id = pol.po_line_id
1026: AND Nvl(pll.cancel_flag,'N') = 'N'
1027: and pll.receiving_routing_id = 3)
1028: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID
1029: and pd.po_line_id = pol.po_line_id
1030: and pd.po_release_id = p_poReleaseID
1031: and ((p_projectId is null or pd.project_id = p_projectId)
1032: and (p_taskId is null or pd.task_id = p_taskId)

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

1073: and pol.ITEM_ID is null
1074: and pol.item_description is not null
1075: and pol.po_header_id = p_poHeaderID
1076: and pol.item_description like p_concatenated_segments
1077: and exists (select 1 from po_distributions_all pd where pd.po_header_id = p_poHeaderID
1078: and pd.po_line_id = pol.po_line_id
1079: and pd.po_release_id = p_poReleaseID
1080: and ((p_projectId is null or pd.project_id = p_projectId)
1081: and (p_taskId is null or pd.task_id = p_taskId)

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

1138: and pll.po_release_id = p_poReleaseID
1139: and pll.po_line_id = pol.po_line_id
1140: AND Nvl(pll.cancel_flag,'N') = 'N'
1141: and pll.receiving_routing_id = 3)
1142: and exists (select 1 from po_distributions_all pd where pd.po_header_id =
1143: p_poHeaderID
1144: and pd.po_line_id = pol.po_line_id
1145: and pd.po_release_id = p_poReleaseID
1146: and ((p_projectId is null or pd.project_id = p_projectId)

Line 1198: ) and exists (select 1 from po_distributions_all pd

1194: and pll.po_header_id = p_poHeaderID
1195: and pll.po_line_id = p_poLineID
1196: AND Nvl(pll.cancel_flag,'N') = 'N'
1197: and pll.receiving_routing_id = 3
1198: ) and exists (select 1 from po_distributions_all pd
1199: where pd.po_header_id = p_poHeaderID
1200: and pd.po_line_id = p_poLineID
1201: and pd.po_line_id = pol.po_line_id
1202: and ((p_projectId is null or pd.project_id = p_projectId)

Line 1260: and exists ( select 1 from po_distributions_all pd

1256: and pll.po_header_id = pol.po_header_id
1257: and pll.po_line_id = pol.po_line_id
1258: AND Nvl(pll.cancel_flag,'N') = 'N'
1259: and pll.receiving_routing_id = 3)
1260: and exists ( select 1 from po_distributions_all pd
1261: where pd.po_header_id = p_poHeaderID
1262: and pd.po_line_id = p_poLineID
1263: and pd.po_line_id = pol.po_line_id
1264: and ((p_projectId is null or pd.project_id = p_projectId)

Line 1315: and exists (select 1 from po_distributions_all pd

1311: and pll.po_header_id = p_poHeaderID
1312: and pll.po_line_id = p_poLineID
1313: AND Nvl(pll.cancel_flag,'N') = 'N'
1314: and pll.receiving_routing_id = 3)
1315: and exists (select 1 from po_distributions_all pd
1316: where pd.po_header_id = p_poHeaderID
1317: and pd.po_line_id = pol.po_line_id
1318: and pd.po_line_id = p_poLineID
1319: and ((p_projectId is null or pd.project_id = p_projectId)

Line 1365: and exists ( select 1 from po_distributions_all pd

1361: and pol.ITEM_ID is null
1362: and pol.item_description is not null
1363: and pol.po_header_id = p_poHeaderID
1364: and pol.item_description like p_concatenated_segments
1365: and exists ( select 1 from po_distributions_all pd
1366: where pd.po_header_id = p_poHeaderID
1367: and pd.po_line_id = p_poLineID
1368: and pd.po_line_id = pol.po_line_id
1369: and ((p_projectId is null or pd.project_id = p_projectId)

Line 1431: ) and exists (select 1 from po_distributions_all pd

1427: and pll.po_header_id = p_poHeaderID
1428: and pll.po_line_id = p_poLineID
1429: AND Nvl(pll.cancel_flag,'N') = 'N'
1430: and pll.receiving_routing_id = 3
1431: ) and exists (select 1 from po_distributions_all pd
1432: where pd.po_header_id = p_poHeaderID
1433: and pd.po_line_id = pol.po_line_id
1434: and pd.po_line_id = p_poLineID
1435: and ((p_projectId is null or pd.project_id = p_projectId)

Line 1487: (select 1 from po_distributions_all pd

1483: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1484: AND Nvl(pll.cancel_flag,'N') = 'N'
1485: and pll.receiving_routing_id = 3)
1486: and exists
1487: (select 1 from po_distributions_all pd
1488: where pd.po_header_id = p_poHeaderID
1489: and pd.po_line_id = pol.po_line_id
1490: and ((p_projectId is null or pd.project_id = p_projectId)
1491: and (p_taskId is null or pd.task_id = p_taskId)

Line 1548: (select 1 from po_distributions_all pd

1544: and pll.po_line_id = pol.po_line_id
1545: AND Nvl(pll.cancel_flag,'N') = 'N'
1546: and pll.receiving_routing_id = 3)
1547: and exists
1548: (select 1 from po_distributions_all pd
1549: where pd.po_header_id = p_poHeaderID
1550: and pd.po_line_id = pol.po_line_id
1551: and ((p_projectId is null or pd.project_id = p_projectId)
1552: and (p_taskId is null or pd.task_id = p_taskId)

Line 1602: (select 1 from po_distributions_all pd

1598: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1599: AND Nvl(pll.cancel_flag,'N') = 'N'
1600: and pll.receiving_routing_id = 3)
1601: and exists
1602: (select 1 from po_distributions_all pd
1603: where pd.po_header_id = p_poHeaderID
1604: and pd.po_line_id = pol.po_line_id
1605: and ((p_projectId is null or pd.project_id = p_projectId)
1606: and (p_taskId is null or pd.task_id = p_taskId)

Line 1652: (select 1 from po_distributions_all pd

1648: and pol.item_description is not null
1649: and pol.po_header_id = p_poHeaderID
1650: and pol.item_description like p_concatenated_segments
1651: and exists
1652: (select 1 from po_distributions_all pd
1653: where pd.po_header_id = p_poHeaderID
1654: and pd.po_line_id = pol.po_line_id
1655: and ((p_projectId is null or pd.project_id = p_projectId)
1656: and (p_taskId is null or pd.task_id = p_taskId)

Line 1717: (select 1 from po_distributions_all pd

1713: and pll.po_header_id = p_poHeaderID and pll.po_line_id = pl.po_line_id
1714: AND Nvl(pll.cancel_flag,'N') = 'N'
1715: and pll.receiving_routing_id = 3)
1716: and exists
1717: (select 1 from po_distributions_all pd
1718: where pd.po_header_id = p_poHeaderID
1719: and pd.po_line_id = pol.po_line_id
1720: and ((p_projectId is null or pd.project_id = p_projectId)
1721: and (p_taskId is null or pd.task_id = p_taskId)