DBA Data[Home] [Help]

APPS.PO_REQ_LINES_SV1 dependencies on MTL_SYSTEM_ITEMS

Line 107: x_stock_enabled_flag mtl_system_items.stock_enabled_flag%type;

103: x_sob_id IN OUT NOCOPY NUMBER) IS
104:
105: x_progress VARCHAR2(3) := NULL;
106:
107: x_stock_enabled_flag mtl_system_items.stock_enabled_flag%type;
108: x_internal_orderable mtl_system_items.internal_order_enabled_flag%type;
109: x_purchasing_enabled_flag mtl_system_items.purchasing_enabled_flag%type;
110: x_outside_operation_flag mtl_system_items.outside_operation_flag%type;
111: x_inventory_asset_flag mtl_system_items.inventory_asset_flag%type;

Line 108: x_internal_orderable mtl_system_items.internal_order_enabled_flag%type;

104:
105: x_progress VARCHAR2(3) := NULL;
106:
107: x_stock_enabled_flag mtl_system_items.stock_enabled_flag%type;
108: x_internal_orderable mtl_system_items.internal_order_enabled_flag%type;
109: x_purchasing_enabled_flag mtl_system_items.purchasing_enabled_flag%type;
110: x_outside_operation_flag mtl_system_items.outside_operation_flag%type;
111: x_inventory_asset_flag mtl_system_items.inventory_asset_flag%type;
112:

Line 109: x_purchasing_enabled_flag mtl_system_items.purchasing_enabled_flag%type;

105: x_progress VARCHAR2(3) := NULL;
106:
107: x_stock_enabled_flag mtl_system_items.stock_enabled_flag%type;
108: x_internal_orderable mtl_system_items.internal_order_enabled_flag%type;
109: x_purchasing_enabled_flag mtl_system_items.purchasing_enabled_flag%type;
110: x_outside_operation_flag mtl_system_items.outside_operation_flag%type;
111: x_inventory_asset_flag mtl_system_items.inventory_asset_flag%type;
112:
113: X_inventory_org_id NUMBER;

Line 110: x_outside_operation_flag mtl_system_items.outside_operation_flag%type;

106:
107: x_stock_enabled_flag mtl_system_items.stock_enabled_flag%type;
108: x_internal_orderable mtl_system_items.internal_order_enabled_flag%type;
109: x_purchasing_enabled_flag mtl_system_items.purchasing_enabled_flag%type;
110: x_outside_operation_flag mtl_system_items.outside_operation_flag%type;
111: x_inventory_asset_flag mtl_system_items.inventory_asset_flag%type;
112:
113: X_inventory_org_id NUMBER;
114: X_planned_item_flag VARCHAR2(1);

Line 111: x_inventory_asset_flag mtl_system_items.inventory_asset_flag%type;

107: x_stock_enabled_flag mtl_system_items.stock_enabled_flag%type;
108: x_internal_orderable mtl_system_items.internal_order_enabled_flag%type;
109: x_purchasing_enabled_flag mtl_system_items.purchasing_enabled_flag%type;
110: x_outside_operation_flag mtl_system_items.outside_operation_flag%type;
111: x_inventory_asset_flag mtl_system_items.inventory_asset_flag%type;
112:
113: X_inventory_org_id NUMBER;
114: X_planned_item_flag VARCHAR2(1);
115: X_outside_op_uom_type mtl_system_items.outside_operation_uom_type%type;

Line 115: X_outside_op_uom_type mtl_system_items.outside_operation_uom_type%type;

111: x_inventory_asset_flag mtl_system_items.inventory_asset_flag%type;
112:
113: X_inventory_org_id NUMBER;
114: X_planned_item_flag VARCHAR2(1);
115: X_outside_op_uom_type mtl_system_items.outside_operation_uom_type%type;
116: X_invoice_close_tolerance mtl_system_items.invoice_close_tolerance%type;
117: X_receive_close_tolerance mtl_system_items.receive_close_tolerance%type;
118: X_receipt_required_flag VARCHAR2(1);
119:

Line 116: X_invoice_close_tolerance mtl_system_items.invoice_close_tolerance%type;

112:
113: X_inventory_org_id NUMBER;
114: X_planned_item_flag VARCHAR2(1);
115: X_outside_op_uom_type mtl_system_items.outside_operation_uom_type%type;
116: X_invoice_close_tolerance mtl_system_items.invoice_close_tolerance%type;
117: X_receive_close_tolerance mtl_system_items.receive_close_tolerance%type;
118: X_receipt_required_flag VARCHAR2(1);
119:
120: x_customer_id po_location_associations.customer_id%type;

Line 117: X_receive_close_tolerance mtl_system_items.receive_close_tolerance%type;

113: X_inventory_org_id NUMBER;
114: X_planned_item_flag VARCHAR2(1);
115: X_outside_op_uom_type mtl_system_items.outside_operation_uom_type%type;
116: X_invoice_close_tolerance mtl_system_items.invoice_close_tolerance%type;
117: X_receive_close_tolerance mtl_system_items.receive_close_tolerance%type;
118: X_receipt_required_flag VARCHAR2(1);
119:
120: x_customer_id po_location_associations.customer_id%type;
121: x_address_id po_location_associations.address_id%type;

Line 127: x_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE:= NULL;

123:
124: x_error_type VARCHAR2(50);
125:
126: --
127: x_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE:= NULL;
128: x_grade_control_flag mtl_system_items.grade_control_flag%TYPE:= NULL;
129: x_secondary_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE:= NULL;
130: x_secondary_unit_of_measure_tl mtl_units_of_measure.unit_of_measure_tl%TYPE:= NULL;
131: --

Line 128: x_grade_control_flag mtl_system_items.grade_control_flag%TYPE:= NULL;

124: x_error_type VARCHAR2(50);
125:
126: --
127: x_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE:= NULL;
128: x_grade_control_flag mtl_system_items.grade_control_flag%TYPE:= NULL;
129: x_secondary_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE:= NULL;
130: x_secondary_unit_of_measure_tl mtl_units_of_measure.unit_of_measure_tl%TYPE:= NULL;
131: --
132:

Line 531: FROM mtl_system_items

527: x_progress := '020';
528:
529: SELECT primary_unit_of_measure
530: INTO x_primary_uom
531: FROM mtl_system_items
532: WHERE inventory_item_id = x_item_id
533: AND organization_id = x_organization_id;
534:
535: /*