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 4030: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */

4026: NVL(a.SECONDARY_DEFAULT_IND,''),
4027: NVL(a.TRACKING_QUANTITY_IND,'P'),
4028: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4029: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4030: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */
4031: WHERE b.to_organization_id = p_organization_id
4032: AND b.po_header_id = p_source_id
4033: AND b.inspection_status_code = 'NOT INSPECTED'
4034: AND b.routing_id = 2 /* Inspection routing */

Line 4090: rcv_transactions_v b,

4086: NVL(a.TRACKING_QUANTITY_IND,'P'),
4087: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4088: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4089: FROM mtl_system_items_vl a, /* Bug 5581528 */
4090: rcv_transactions_v b,
4091: mtl_cross_references mcr
4092: WHERE b.to_organization_id = p_organization_id
4093: AND b.po_header_id = p_source_id
4094: AND b.inspection_status_code = 'NOT INSPECTED'

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

4149: NVL(a.SECONDARY_DEFAULT_IND,''),
4150: NVL(a.TRACKING_QUANTITY_IND,'P'),
4151: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4152: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4153: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */
4154: WHERE b.to_organization_id = p_organization_id
4155: AND b.shipment_header_id = p_source_id
4156: AND b.receipt_source_code <> 'VENDOR'
4157: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4214: rcv_transactions_v b,

4210: NVL(a.TRACKING_QUANTITY_IND,'P'),
4211: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4212: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4213: FROM mtl_system_items_vl a, /* Bug 5581528 */
4214: rcv_transactions_v b,
4215: mtl_cross_references mcr
4216: WHERE b.to_organization_id = p_organization_id
4217: AND b.shipment_header_id = p_source_id
4218: AND b.receipt_source_code <> 'VENDOR'

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

4275: NVL(a.SECONDARY_DEFAULT_IND,''),
4276: NVL(a.TRACKING_QUANTITY_IND,'P'),
4277: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4278: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4279: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */
4280: WHERE b.to_organization_id = p_organization_id
4281: AND b.oe_order_header_id = p_source_id
4282: AND b.receipt_source_code <> 'VENDOR'
4283: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4340: rcv_transactions_v b,

4336: NVL(a.TRACKING_QUANTITY_IND,'P'),
4337: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4338: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4339: FROM mtl_system_items_vl a, /* Bug 5581528 */
4340: rcv_transactions_v b,
4341: mtl_cross_references mcr
4342: WHERE b.to_organization_id = p_organization_id
4343: AND b.oe_order_header_id = p_source_id
4344: AND b.receipt_source_code <> 'VENDOR'

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

4401: NVL(a.SECONDARY_DEFAULT_IND,''),
4402: NVL(a.TRACKING_QUANTITY_IND,'P'),
4403: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4404: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4405: FROM mtl_system_items_vl a, rcv_transactions_v b /* Bug 5581528 */
4406: WHERE b.to_organization_id = p_organization_id
4407: AND b.shipment_header_id = TO_CHAR(p_source_id)
4408: AND b.inspection_status_code = 'NOT INSPECTED'
4409: AND b.routing_id = 2 /* Inspection routing */

Line 4465: rcv_transactions_v b,

4461: NVL(a.TRACKING_QUANTITY_IND,'P'),
4462: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4463: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4464: FROM mtl_system_items_vl a, /* Bug 5581528 */
4465: rcv_transactions_v b,
4466: mtl_cross_references mcr
4467: WHERE b.to_organization_id = p_organization_id
4468: AND b.shipment_header_id = TO_CHAR(p_source_id)
4469: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4531: rcv_transactions_v b,

4527: NVL(a.TRACKING_QUANTITY_IND,'P'),
4528: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4529: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4530: FROM mtl_system_items_vl a, /* Bug 5581528 */
4531: rcv_transactions_v b,
4532: (SELECT DISTINCT rsl.shipment_header_id
4533: FROM po_requisition_lines pol,
4534: rcv_shipment_lines rsl
4535: WHERE pol.requisition_header_id = p_source_id

Line 4598: rcv_transactions_v b,

4594: NVL(a.TRACKING_QUANTITY_IND,'P'),
4595: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4596: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4597: FROM mtl_system_items_vl a, /* Bug 5581528 */
4598: rcv_transactions_v b,
4599: mtl_cross_references mcr,
4600: (SELECT DISTINCT rsl.shipment_header_id
4601: FROM po_requisition_lines pol,
4602: rcv_shipment_lines rsl

Line 4653: FROM mtl_item_revisions a, rcv_transactions_v b

4649: OPEN x_revs FOR
4650: SELECT DISTINCT a.revision
4651: , a.effectivity_date
4652: , NVL(a.description, '')
4653: FROM mtl_item_revisions a, rcv_transactions_v b
4654: WHERE b.to_organization_id = p_organization_id
4655: AND b.item_id = p_inventory_item_id
4656: AND b.po_header_id = p_source_id
4657: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4668: FROM mtl_item_revisions a, rcv_transactions_v b

4664: OPEN x_revs FOR
4665: SELECT DISTINCT a.revision
4666: , a.effectivity_date
4667: , NVL(a.description, '')
4668: FROM mtl_item_revisions a, rcv_transactions_v b
4669: WHERE b.to_organization_id = p_organization_id
4670: AND b.item_id = p_inventory_item_id
4671: AND b.receipt_source_code <> 'VENDOR'
4672: AND b.shipment_header_id = p_source_id

Line 4684: FROM mtl_item_revisions a, rcv_transactions_v b

4680: OPEN x_revs FOR
4681: SELECT DISTINCT a.revision
4682: , a.effectivity_date
4683: , NVL(a.description, '')
4684: FROM mtl_item_revisions a, rcv_transactions_v b
4685: WHERE b.to_organization_id = p_organization_id
4686: AND b.item_id = p_inventory_item_id
4687: AND b.receipt_source_code <> 'VENDOR'
4688: AND b.oe_order_header_id = p_source_id

Line 4700: FROM mtl_item_revisions a, rcv_transactions_v b

4696: OPEN x_revs FOR
4697: SELECT DISTINCT a.revision
4698: , a.effectivity_date
4699: , NVL(a.description, '')
4700: FROM mtl_item_revisions a, rcv_transactions_v b
4701: WHERE b.to_organization_id = p_organization_id
4702: AND b.item_id = p_inventory_item_id
4703: AND b.shipment_header_id = TO_CHAR(p_source_id)
4704: AND b.inspection_status_code = 'NOT INSPECTED'