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_ITEM_LOVS dependencies on RCV_TRANSACTIONS_V

Line 4282: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */

4278: NVL(a.SECONDARY_DEFAULT_IND,''),
4279: NVL(a.TRACKING_QUANTITY_IND,'P'),
4280: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4281: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4282: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */
4283: WHERE b.to_organization_id = p_organization_id
4284: AND b.po_header_id = p_source_id
4285: AND b.inspection_status_code = 'NOT INSPECTED'
4286: AND b.routing_id = 2 /* Inspection routing */

Line 4349: rcv_transactions_v b,

4345: NVL(a.TRACKING_QUANTITY_IND,'P'),
4346: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4347: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4348: FROM mtl_system_items_vl a, /* Bug 5581528 */
4349: rcv_transactions_v b,
4350: mtl_cross_references mcr
4351: WHERE b.to_organization_id = p_organization_id
4352: AND b.po_header_id = p_source_id
4353: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4413: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */

4409: NVL(a.SECONDARY_DEFAULT_IND,''),
4410: NVL(a.TRACKING_QUANTITY_IND,'P'),
4411: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4412: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4413: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */
4414: WHERE b.to_organization_id = p_organization_id
4415: AND b.shipment_header_id = p_source_id
4416: AND b.receipt_source_code <> 'VENDOR'
4417: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4475: rcv_transactions_v b,

4471: NVL(a.TRACKING_QUANTITY_IND,'P'),
4472: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4473: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4474: FROM mtl_system_items_vl a, /* Bug 5581528 */
4475: rcv_transactions_v b,
4476: mtl_cross_references mcr
4477: WHERE b.to_organization_id = p_organization_id
4478: AND b.shipment_header_id = p_source_id
4479: AND b.receipt_source_code <> 'VENDOR'

Line 4541: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */

4537: NVL(a.SECONDARY_DEFAULT_IND,''),
4538: NVL(a.TRACKING_QUANTITY_IND,'P'),
4539: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4540: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4541: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */
4542: WHERE b.to_organization_id = p_organization_id
4543: AND b.oe_order_header_id = p_source_id
4544: AND b.receipt_source_code <> 'VENDOR'
4545: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4603: rcv_transactions_v b,

4599: NVL(a.TRACKING_QUANTITY_IND,'P'),
4600: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4601: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4602: FROM mtl_system_items_vl a, /* Bug 5581528 */
4603: rcv_transactions_v b,
4604: mtl_cross_references mcr
4605: WHERE b.to_organization_id = p_organization_id
4606: AND b.oe_order_header_id = p_source_id
4607: AND b.receipt_source_code <> 'VENDOR'

Line 4669: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */

4665: NVL(a.SECONDARY_DEFAULT_IND,''),
4666: NVL(a.TRACKING_QUANTITY_IND,'P'),
4667: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4668: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4669: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */
4670: WHERE b.to_organization_id = p_organization_id
4671: AND b.shipment_header_id = TO_CHAR(p_source_id)
4672: AND b.inspection_status_code = 'NOT INSPECTED'
4673: AND b.routing_id = 2 /* Inspection routing */

Line 4736: rcv_transactions_v b,

4732: NVL(a.TRACKING_QUANTITY_IND,'P'),
4733: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4734: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4735: FROM mtl_system_items_vl a, /* Bug 5581528 */
4736: rcv_transactions_v b,
4737: mtl_cross_references mcr
4738: WHERE b.to_organization_id = p_organization_id
4739: AND b.shipment_header_id = TO_CHAR(p_source_id)
4740: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4803: rcv_transactions_v b,

4799: NVL(a.TRACKING_QUANTITY_IND,'P'),
4800: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4801: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4802: FROM mtl_system_items_vl a, /* Bug 5581528 */
4803: rcv_transactions_v b,
4804: (SELECT DISTINCT rsl.shipment_header_id
4805: FROM po_requisition_lines pol,
4806: rcv_shipment_lines rsl
4807: WHERE pol.requisition_header_id = p_source_id

Line 4871: rcv_transactions_v b,

4867: NVL(a.TRACKING_QUANTITY_IND,'P'),
4868: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4869: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4870: FROM mtl_system_items_vl a, /* Bug 5581528 */
4871: rcv_transactions_v b,
4872: mtl_cross_references mcr,
4873: (SELECT DISTINCT rsl.shipment_header_id
4874: FROM po_requisition_lines pol,
4875: rcv_shipment_lines rsl

Line 4926: FROM mtl_item_revisions a, rcv_transactions_v b

4922: OPEN x_revs FOR
4923: SELECT DISTINCT a.revision
4924: , a.effectivity_date
4925: , NVL(a.description, '')
4926: FROM mtl_item_revisions a, rcv_transactions_v b
4927: WHERE b.to_organization_id = p_organization_id
4928: AND b.item_id = p_inventory_item_id
4929: AND b.po_header_id = p_source_id
4930: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4941: FROM mtl_item_revisions a, rcv_transactions_v b

4937: OPEN x_revs FOR
4938: SELECT DISTINCT a.revision
4939: , a.effectivity_date
4940: , NVL(a.description, '')
4941: FROM mtl_item_revisions a, rcv_transactions_v b
4942: WHERE b.to_organization_id = p_organization_id
4943: AND b.item_id = p_inventory_item_id
4944: AND b.receipt_source_code <> 'VENDOR'
4945: AND b.shipment_header_id = p_source_id

Line 4957: FROM mtl_item_revisions a, rcv_transactions_v b

4953: OPEN x_revs FOR
4954: SELECT DISTINCT a.revision
4955: , a.effectivity_date
4956: , NVL(a.description, '')
4957: FROM mtl_item_revisions a, rcv_transactions_v b
4958: WHERE b.to_organization_id = p_organization_id
4959: AND b.item_id = p_inventory_item_id
4960: AND b.receipt_source_code <> 'VENDOR'
4961: AND b.oe_order_header_id = p_source_id

Line 4973: FROM mtl_item_revisions a, rcv_transactions_v b

4969: OPEN x_revs FOR
4970: SELECT DISTINCT a.revision
4971: , a.effectivity_date
4972: , NVL(a.description, '')
4973: FROM mtl_item_revisions a, rcv_transactions_v b
4974: WHERE b.to_organization_id = p_organization_id
4975: AND b.item_id = p_inventory_item_id
4976: AND b.shipment_header_id = TO_CHAR(p_source_id)
4977: AND b.inspection_status_code = 'NOT INSPECTED'