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 3181: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty --BUG12820609

3177: , NVL(a.lot_status_enabled, 'N')
3178: , ''
3179: , 'N'
3180: , a.inventory_item_flag
3181: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty --BUG12820609
3182: , wms_deploy.get_item_client_name(a.inventory_item_id),
3183: --Bug No 3952081
3184: --Additional Fields for Process Convergence
3185: NVL(a.GRADE_CONTROL_FLAG,'N'),

Line 3210: -- 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) --BUG12820609 added outer select to reduce the call see where

3206: AND b.inventory_item_id = a.inventory_item_id
3207: AND a.concatenated_segments LIKE (p_concatenated_segments||l_append)
3208: AND Nvl(b.wms_process_flag,-1) <> 2
3209: AND b.line_status <> 5 --BUG12820609 closed MTRL's do not matter in Inspect Item LOV
3210: -- 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) --BUG12820609 added outer select to reduce the call see where
3211: ) WHERE insp_qty > 0 --BUG12820609 added as function call was reduced to one
3212: --Changes for GTIN
3213: UNION
3214: --BUG12820609 refer changes in above select, same done in below 2 select statements

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

3236: , NVL(a.lot_status_enabled, 'N')
3237: , mcr.cross_reference
3238: , 'N'
3239: , a.inventory_item_flag
3240: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty
3241: , wms_deploy.get_item_client_name(a.inventory_item_id),
3242: --Bug No 3952081
3243: --Additional Fields for Process Convergence
3244: NVL(a.GRADE_CONTROL_FLAG,'N'),

Line 3268: -- 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)

3264: AND b.inspection_status is not null -- 8405606
3265: AND b.organization_id = a.organization_id
3266: AND b.inventory_item_id = a.inventory_item_id
3267: AND Nvl(b.wms_process_flag,-1) <> 2
3268: -- 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)
3269: AND a.inventory_item_id = mcr.inventory_item_id
3270: AND mcr.cross_reference_type = g_gtin_cross_ref_type
3271: AND mcr.cross_reference LIKE l_cross_ref
3272: AND (mcr.organization_id = a.organization_id

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

3302: , NVL(a.lot_status_enabled, 'N')
3303: , ''
3304: , 'N'
3305: , a.inventory_item_flag
3306: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty
3307: , wms_deploy.get_item_client_name(a.inventory_item_id),
3308: --Bug No 3952081
3309: --Additional Fields for Process Convergence
3310: NVL(a.GRADE_CONTROL_FLAG,'N'),

Line 3334: -- 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)

3330: AND b.organization_id = a.organization_id
3331: AND b.inventory_item_id = a.inventory_item_id
3332: -- bug#13092838 AND a.concatenated_segments LIKE (p_concatenated_segments||l_append)
3333: AND Nvl(b.wms_process_flag,-1) <> 2
3334: -- 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)
3335: AND b.line_status <> 5
3336: ) WHERE insp_qty > 0;
3337:
3338: ELSE

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

3362: , NVL(a.lot_status_enabled, 'N')
3363: , ''
3364: , 'N'
3365: , a.inventory_item_flag
3366: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty
3367: , wms_deploy.get_item_client_name(a.inventory_item_id),
3368: --Bug No 3952081
3369: --Additional Fields for Process Convergence
3370: NVL(a.GRADE_CONTROL_FLAG,'N'),

Line 3394: -- 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)

3390: AND b.organization_id = a.organization_id
3391: AND b.inventory_item_id = a.inventory_item_id
3392: AND a.concatenated_segments LIKE (p_concatenated_segments||l_append)
3393: AND Nvl(b.wms_process_flag,-1) <> 2
3394: -- 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)
3395: AND b.line_status <> 5
3396: ) WHERE insp_qty > 0;
3397: END IF;
3398: END get_inspect_item_lov;

Line 4260: , (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))

4256: , NVL(a.lot_status_enabled, 'N')
4257: , ''
4258: , 'N'
4259: , a.inventory_item_flag
4260: , (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))
4261: , wms_deploy.get_item_client_name(a.inventory_item_id)
4262: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4263: , a.outside_operation_flag,
4264: --Bug No 3952081

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

4292: from po_lines_all pla
4293: where pla.po_header_id=b.po_header_id and
4294: pla.po_line_id=b.po_line_id and
4295: pla.vendor_product_num like (p_concatenated_segments)))
4296: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO',
4297: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4298:
4299: --Changes for GTIN
4300:

Line 4326: , (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))

4322: , NVL(a.lot_status_enabled, 'N')
4323: , mcr.cross_reference
4324: , 'N'
4325: , a.inventory_item_flag
4326: , (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))
4327: , wms_deploy.get_item_client_name(a.inventory_item_id)
4328: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4329: , a.outside_operation_flag,
4330: --Bug No 3952081

Line 4357: 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

4353: AND b.inspection_status_code = 'NOT INSPECTED'
4354: AND b.routing_id = 2 /* Inspection routing */
4355: AND b.to_organization_id = a.organization_id
4356: AND b.item_id = a.inventory_item_id
4357: 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
4358: AND a.inventory_item_id = mcr.inventory_item_id
4359: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4360: AND mcr.cross_reference LIKE l_cross_ref
4361: AND (mcr.organization_id = a.organization_id

Line 4391: , (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))

4387: , NVL(a.lot_status_enabled, 'N')
4388: , ''
4389: , 'N'
4390: , a.inventory_item_flag
4391: , (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))
4392: , wms_deploy.get_item_client_name(a.inventory_item_id)
4393: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4394: , a.outside_operation_flag,
4395: --Bug No 3952081

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

4418: AND b.routing_id = 2 /* Inspection routing */
4419: AND b.to_organization_id = a.organization_id
4420: AND b.item_id = a.inventory_item_id
4421: AND a.concatenated_segments LIKE (p_concatenated_segments||l_append)
4422: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',
4423: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4424:
4425: --Changes for GTIN
4426: UNION

Line 4452: , (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))

4448: , NVL(a.lot_status_enabled, 'N')
4449: , mcr.cross_reference
4450: , 'N'
4451: , a.inventory_item_flag
4452: , (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))
4453: , wms_deploy.get_item_client_name(a.inventory_item_id)
4454: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4455: , a.outside_operation_flag,
4456: --Bug No 3952081

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

4480: AND b.inspection_status_code = 'NOT INSPECTED'
4481: AND b.routing_id = 2 /* Inspection routing */
4482: AND b.to_organization_id = a.organization_id
4483: AND b.item_id = a.inventory_item_id
4484: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',
4485: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4486: AND a.inventory_item_id = mcr.inventory_item_id
4487: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4488: AND mcr.cross_reference LIKE l_cross_ref

Line 4519: , (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))

4515: , NVL(a.lot_status_enabled, 'N')
4516: , ''
4517: , 'N'
4518: , a.inventory_item_flag
4519: , (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))
4520: , wms_deploy.get_item_client_name(a.inventory_item_id)
4521: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4522: , a.outside_operation_flag,
4523: --Bug No 3952081

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

4546: AND b.routing_id = 2 /* Inspection routing */
4547: AND b.to_organization_id = a.organization_id
4548: AND b.item_id = a.inventory_item_id
4549: AND a.concatenated_segments LIKE (p_concatenated_segments||l_append)
4550: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA',
4551: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4552:
4553: --Changes for GTIN
4554: UNION

Line 4580: , (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))

4576: , NVL(a.lot_status_enabled, 'N')
4577: , mcr.cross_reference
4578: , 'N'
4579: , a.inventory_item_flag
4580: , (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))
4581: , wms_deploy.get_item_client_name(a.inventory_item_id)
4582: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4583: , a.outside_operation_flag,
4584: --Bug No 3952081

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

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

Line 4647: , (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))

4643: , NVL(a.lot_status_enabled, 'N')
4644: , ''
4645: , 'N'
4646: , a.inventory_item_flag
4647: , (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))
4648: , wms_deploy.get_item_client_name(a.inventory_item_id)
4649: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4650: , a.outside_operation_flag,
4651: --Bug No 3952081

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

4679: from po_lines_all pla
4680: where pla.po_header_id=b.po_header_id and
4681: pla.po_line_id=b.po_line_id and
4682: pla.vendor_product_num like (p_concatenated_segments)))
4683: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT',
4684: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4685:
4686: --Changes for GTIN
4687: UNION

Line 4713: , (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))

4709: , NVL(a.lot_status_enabled, 'N')
4710: , mcr.cross_reference
4711: , 'N'
4712: , a.inventory_item_flag
4713: , (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))
4714: , wms_deploy.get_item_client_name(a.inventory_item_id)
4715: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4716: , a.outside_operation_flag,
4717: --Bug No 3952081

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

4740: AND b.inspection_status_code = 'NOT INSPECTED'
4741: AND b.routing_id = 2 /* Inspection routing */
4742: AND b.to_organization_id = a.organization_id
4743: AND b.item_id = a.inventory_item_id
4744: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT',
4745: p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4746: AND a.inventory_item_id = mcr.inventory_item_id
4747: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4748: AND mcr.cross_reference LIKE l_cross_ref

Line 4780: , (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))

4776: , NVL(a.lot_status_enabled, 'N')
4777: , ''
4778: , 'N'
4779: , a.inventory_item_flag
4780: , (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))
4781: , wms_deploy.get_item_client_name(a.inventory_item_id)
4782: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4783: , a.outside_operation_flag,
4784: --Bug No 3952081

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

4814: AND b.routing_id = 2 /* Inspection routing */
4815: AND b.to_organization_id = a.organization_id
4816: AND b.item_id = a.inventory_item_id
4817: AND a.concatenated_segments LIKE (p_concatenated_segments||l_append)
4818: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',
4819: shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4820:
4821: --Changes for GTIN
4822: UNION

Line 4848: , (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))

4844: , NVL(a.lot_status_enabled, 'N')
4845: , mcr.cross_reference
4846: , 'N'
4847: , a.inventory_item_flag
4848: , (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))
4849: , wms_deploy.get_item_client_name(a.inventory_item_id)
4850: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4851: , a.outside_operation_flag,
4852: --Bug No 3952081

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

4882: AND b.inspection_status_code = 'NOT INSPECTED'
4883: AND b.routing_id = 2 /* Inspection routing */
4884: AND b.to_organization_id = a.organization_id
4885: AND b.item_id = a.inventory_item_id
4886: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP',
4887: shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code)) > 0
4888: AND a.inventory_item_id = mcr.inventory_item_id
4889: AND mcr.cross_reference_type = g_gtin_cross_ref_type
4890: AND mcr.cross_reference LIKE l_cross_ref