APPS.PO_ITEMS_SV dependencies on MTL_SYSTEM_ITEMS

Line 5: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE

1: PACKAGE BODY PO_ITEMS_SV as
2: /* $Header: POXCOI1B.pls 120.2 2006/10/05 19:40:11 bao noship $ */
3: /*============================= PO_ITEMS_SV ===============================*/
4: g_chktype_TRACKING_QTY_IND_S CONSTANT
5: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE
6: := 'PS'; --
7: /*===========================================================================
8:
9: FUNCTION NAME: val_category()

Line 74: FROM mtl_system_items msi

70: IF (X_item_revision IS NULL) THEN
71:
72: SELECT MAX('Y') /*'item valid in the defaulted ship org'*/
73: INTO X_item_valid
74: FROM mtl_system_items msi
75: WHERE msi.inventory_item_id = X_item_id
76: AND msi.organization_id = X_master_ship_org_id
77: AND msi.purchasing_enabled_flag = 'Y'
78: AND ( ( X_outside_operation_flag = 'Y'

Line 98: FROM mtl_system_items msi,

94: ** valid for the selected organization.
95: */
96: SELECT MAX('Y')
97: INTO X_item_valid
98: FROM mtl_system_items msi,
99: mtl_item_revisions mir
100: WHERE mir.organization_id = X_master_ship_org_id
101: AND mir.revision = X_item_revision
102: AND mir.inventory_item_id = X_item_id

Line 361: mtl_system_items msi,

357: X_secondary_unit_of_measure
358: --
359: FROM mtl_units_of_measure mum,
360: mtl_item_categories mic,
361: mtl_system_items msi,
362: mtl_parameters mpa,
363: mtl_units_of_measure mum2 --
364: WHERE mic.inventory_item_id = X_item_id
365: AND mic.category_set_id = X_category_set_id

Line 439: mtl_system_items msi,

435: X_secondary_unit_of_measure
436: --
437: FROM mtl_units_of_measure mum,
438: mtl_item_categories mic,
439: mtl_system_items msi,
440: mtl_units_of_measure mum2 --
441: WHERE msi.inventory_item_id = X_item_id
442: AND mic.inventory_item_id = X_item_id
443: AND mic.category_set_id = X_category_set_id

Line 457: ** mtl_system_items. So the following SELECT statement

453:
454: /*
455: ** Bug 2198247. The item description should be
456: ** fetched from mtl_system_item_tl not from
457: ** mtl_system_items. So the following SELECT statement
458: ** is added to get the description from mtl_system_items_tl.
459: */
460:
461:

Line 458: ** is added to get the description from mtl_system_items_tl.

454: /*
455: ** Bug 2198247. The item description should be
456: ** fetched from mtl_system_item_tl not from
457: ** mtl_system_items. So the following SELECT statement
458: ** is added to get the description from mtl_system_items_tl.
459: */
460:
461:
462: SELECT description

Line 464: FROM mtl_system_items_tl

460:
461:
462: SELECT description
463: INTO X_item_description
464: FROM mtl_system_items_tl
465: WHERE inventory_item_id = X_item_id
466: AND language = USERENV('LANG')
467: AND organization_id = X_inventory_organization_id;
468:

Line 637: FROM mtl_units_of_measure mum, mtl_system_items msi

633: msi.grade_control_flag,
634: decode(msi.tracking_quantity_ind,
635: g_chktype_TRACKING_QTY_IND_S,mum.unit_of_measure,NULL)
636: INTO X_secondary_default_ind, X_grade_control_flag, X_secondary_unit_of_measure
637: FROM mtl_units_of_measure mum, mtl_system_items msi
638: WHERE msi.organization_id = X_inventory_organization_id
639: AND msi.inventory_item_id = X_item_id
640: AND mum.uom_code(+) = msi.secondary_uom_code ;
641:

Line 647: FROM mtl_system_items msi

643: SELECT decode(msi.tracking_quantity_ind,
644: g_chktype_TRACKING_QTY_IND_S,msi.secondary_default_ind,NULL),
645: msi.grade_control_flag
646: INTO X_secondary_default_ind, X_grade_control_flag
647: FROM mtl_system_items msi
648: WHERE msi.organization_id = X_inventory_organization_id
649: AND msi.inventory_item_id = X_item_id ;
650: END IF;
651: