APPS.PO_LINES_SV3 dependencies on MTL_SYSTEM_ITEMS

Line 5: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE

1: PACKAGE BODY PO_LINES_SV3 as
2: /* $Header: POXPOL3B.pls 120.12 2006/09/07 22:48:38 togeorge noship $ */
3:
4: g_chktype_TRACKING_QTY_IND_S CONSTANT
5: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE
6: := 'PS'; --
7: /*============================= PO_LINES_SV3 ==============================*/
8:
9: /*===========================================================================

Line 206: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;

202: X_secondary_quantity_shipment PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY%TYPE := NULL;
203: X_preferred_grade_shipment MTL_GRADES.GRADE_CODE%TYPE := NULL;-- increased length to 150
204:
205: --
206: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
207: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE;
208: l_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
209: --
210: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --

Line 207: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE;

203: X_preferred_grade_shipment MTL_GRADES.GRADE_CODE%TYPE := NULL;-- increased length to 150
204:
205: --
206: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
207: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE;
208: l_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
209: --
210: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --
211:

Line 523: FROM mtl_system_items msi

519: X_receive_close_tolerance_tmp,
520: temp_receipt_required_flag,
521: temp_inspection_required_flag,
522: l_secondary_default_ind, l_grade_control_flag, l_secondary_uom_code --
523: FROM mtl_system_items msi
524: WHERE msi.inventory_item_id = X_item_id
525: AND msi.organization_id =X_ship_org_id;
526:
527: exception