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 INV_RCV_STD_INSPECT_APIS

Line 3022: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)),

3018: , NVL(a.lot_status_enabled, 'N')
3019: , ''
3020: , 'N'
3021: , a.inventory_item_flag
3022: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)),
3023: --Bug No 3952081
3024: --Additional Fields for Process Convergence
3025: NVL(a.GRADE_CONTROL_FLAG,'N'),
3026: NVL(a.DEFAULT_GRADE,''),

Line 3049: AND ((inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN',

3045: AND b.organization_id = a.organization_id
3046: AND b.inventory_item_id = a.inventory_item_id
3047: AND a.concatenated_segments LIKE (p_concatenated_segments)
3048: AND Nvl(b.wms_process_flag,-1) <> 2
3049: AND ((inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN',
3050: p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0)
3051:
3052: --Changes for GTIN
3053: UNION

Line 3079: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)),

3075: , NVL(a.lot_status_enabled, 'N')
3076: , mcr.cross_reference
3077: , 'N'
3078: , a.inventory_item_flag
3079: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)),
3080: --Bug No 3952081
3081: --Additional Fields for Process Convergence
3082: NVL(a.GRADE_CONTROL_FLAG,'N'),
3083: NVL(a.DEFAULT_GRADE,''),

Line 3107: AND ((inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN',

3103: AND b.inspection_status = 1 /* Yet to be inspected */
3104: AND b.organization_id = a.organization_id
3105: AND b.inventory_item_id = a.inventory_item_id
3106: AND Nvl(b.wms_process_flag,-1) <> 2
3107: AND ((inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN',
3108: p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0)
3109: AND a.inventory_item_id = mcr.inventory_item_id
3110: AND mcr.cross_reference_type = g_gtin_cross_ref_type
3111: AND mcr.cross_reference LIKE l_cross_ref

Line 3143: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)),

3139: , NVL(a.lot_status_enabled, 'N')
3140: , ''
3141: , 'N'
3142: , a.inventory_item_flag
3143: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)),
3144: --Bug No 3952081
3145: --Additional Fields for Process Convergence
3146: NVL(a.GRADE_CONTROL_FLAG,'N'),
3147: NVL(a.DEFAULT_GRADE,''),

Line 3170: AND ((inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0);

3166: AND b.organization_id = a.organization_id
3167: AND b.inventory_item_id = a.inventory_item_id
3168: AND a.concatenated_segments LIKE (p_concatenated_segments)
3169: AND Nvl(b.wms_process_flag,-1) <> 2
3170: AND ((inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0);
3171: END IF;
3172: END get_inspect_item_lov;
3173:
3174: -- Name: GET_INSPECT_REVISION_LOV

Line 4009: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4005: , NVL(a.lot_status_enabled, 'N')
4006: , ''
4007: , 'N'
4008: , a.inventory_item_flag
4009: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4010: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4011: , a.outside_operation_flag,
4012: --Bug No 3952081
4013: --Additional Fields for Process Convergence

Line 4038: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO',

4034: AND b.routing_id = 2 /* Inspection routing */
4035: AND b.to_organization_id = a.organization_id
4036: AND b.item_id = a.inventory_item_id
4037: AND a.concatenated_segments LIKE (p_concatenated_segments)
4038: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO',
4039: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4040:
4041: --Changes for GTIN
4042:

Line 4068: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4064: , NVL(a.lot_status_enabled, 'N')
4065: , mcr.cross_reference
4066: , 'N'
4067: , a.inventory_item_flag
4068: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4069: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4070: , a.outside_operation_flag,
4071: --Bug No 3952081
4072: --Additional Fields for Process Convergence

Line 4098: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0

4094: AND b.inspection_status_code = 'NOT INSPECTED'
4095: AND b.routing_id = 2 /* Inspection routing */
4096: AND b.to_organization_id = a.organization_id
4097: AND b.item_id = a.inventory_item_id
4098: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4099: AND a.inventory_item_id = mcr.inventory_item_id
4100: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4101: AND mcr.cross_reference LIKE l_cross_ref
4102: AND (mcr.organization_id = a.organization_id

Line 4132: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4128: , NVL(a.lot_status_enabled, 'N')
4129: , ''
4130: , 'N'
4131: , a.inventory_item_flag
4132: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4133: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4134: , a.outside_operation_flag,
4135: --Bug No 3952081
4136: --Additional Fields for Process Convergence

Line 4162: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',

4158: AND b.routing_id = 2 /* Inspection routing */
4159: AND b.to_organization_id = a.organization_id
4160: AND b.item_id = a.inventory_item_id
4161: AND a.concatenated_segments LIKE (p_concatenated_segments)
4162: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',
4163: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4164:
4165: --Changes for GTIN
4166: UNION

Line 4192: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4188: , NVL(a.lot_status_enabled, 'N')
4189: , mcr.cross_reference
4190: , 'N'
4191: , a.inventory_item_flag
4192: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4193: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4194: , a.outside_operation_flag,
4195: --Bug No 3952081
4196: --Additional Fields for Process Convergence

Line 4223: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',

4219: AND b.inspection_status_code = 'NOT INSPECTED'
4220: AND b.routing_id = 2 /* Inspection routing */
4221: AND b.to_organization_id = a.organization_id
4222: AND b.item_id = a.inventory_item_id
4223: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',
4224: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4225: AND a.inventory_item_id = mcr.inventory_item_id
4226: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4227: AND mcr.cross_reference LIKE l_cross_ref

Line 4258: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4254: , NVL(a.lot_status_enabled, 'N')
4255: , ''
4256: , 'N'
4257: , a.inventory_item_flag
4258: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4259: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4260: , a.outside_operation_flag,
4261: --Bug No 3952081
4262: --Additional Fields for Process Convergence

Line 4288: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA',

4284: AND b.routing_id = 2 /* Inspection routing */
4285: AND b.to_organization_id = a.organization_id
4286: AND b.item_id = a.inventory_item_id
4287: AND a.concatenated_segments LIKE (p_concatenated_segments)
4288: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA',
4289: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4290:
4291: --Changes for GTIN
4292: UNION

Line 4318: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4314: , NVL(a.lot_status_enabled, 'N')
4315: , mcr.cross_reference
4316: , 'N'
4317: , a.inventory_item_flag
4318: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4319: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4320: , a.outside_operation_flag,
4321: --Bug No 3952081
4322: --Additional Fields for Process Convergence

Line 4349: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA',

4345: AND b.inspection_status_code = 'NOT INSPECTED'
4346: AND b.routing_id = 2 /* Inspection routing */
4347: AND b.to_organization_id = a.organization_id
4348: AND b.item_id = a.inventory_item_id
4349: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA',
4350: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4351: AND a.inventory_item_id = mcr.inventory_item_id
4352: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4353: AND mcr.cross_reference LIKE l_cross_ref

Line 4384: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4380: , NVL(a.lot_status_enabled, 'N')
4381: , ''
4382: , 'N'
4383: , a.inventory_item_flag
4384: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4385: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4386: , a.outside_operation_flag,
4387: --Bug No 3952081
4388: --Additional Fields for Process Convergence

Line 4413: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT',

4409: AND b.routing_id = 2 /* Inspection routing */
4410: AND b.to_organization_id = a.organization_id
4411: AND b.item_id = a.inventory_item_id
4412: AND a.concatenated_segments LIKE (p_concatenated_segments)
4413: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT',
4414: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4415:
4416: --Changes for GTIN
4417: UNION

Line 4443: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4439: , NVL(a.lot_status_enabled, 'N')
4440: , mcr.cross_reference
4441: , 'N'
4442: , a.inventory_item_flag
4443: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4444: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4445: , a.outside_operation_flag,
4446: --Bug No 3952081
4447: --Additional Fields for Process Convergence

Line 4473: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT',

4469: AND b.inspection_status_code = 'NOT INSPECTED'
4470: AND b.routing_id = 2 /* Inspection routing */
4471: AND b.to_organization_id = a.organization_id
4472: AND b.item_id = a.inventory_item_id
4473: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT',
4474: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4475: AND a.inventory_item_id = mcr.inventory_item_id
4476: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4477: AND mcr.cross_reference LIKE l_cross_ref

Line 4509: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4505: , NVL(a.lot_status_enabled, 'N')
4506: , ''
4507: , 'N'
4508: , a.inventory_item_flag
4509: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4510: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4511: , a.outside_operation_flag,
4512: --Bug No 3952081
4513: --Additional Fields for Process Convergence

Line 4546: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',

4542: AND b.routing_id = 2 /* Inspection routing */
4543: AND b.to_organization_id = a.organization_id
4544: AND b.item_id = a.inventory_item_id
4545: AND a.concatenated_segments LIKE (p_concatenated_segments)
4546: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',
4547: shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4548:
4549: --Changes for GTIN
4550: UNION

Line 4576: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))

4572: , NVL(a.lot_status_enabled, 'N')
4573: , mcr.cross_reference
4574: , 'N'
4575: , a.inventory_item_flag
4576: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4577: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4578: , a.outside_operation_flag,
4579: --Bug No 3952081
4580: --Additional Fields for Process Convergence

Line 4613: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',

4609: AND b.inspection_status_code = 'NOT INSPECTED'
4610: AND b.routing_id = 2 /* Inspection routing */
4611: AND b.to_organization_id = a.organization_id
4612: AND b.item_id = a.inventory_item_id
4613: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',
4614: shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4615: AND a.inventory_item_id = mcr.inventory_item_id
4616: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4617: AND mcr.cross_reference LIKE l_cross_ref