DBA Data[Home] [Help]

APPS.INV_LOT_APIS dependencies on MTL_SYSTEM_ITEMS

Line 176: FROM mtl_system_items

172: , expiration_action_code
173: , maturity_days
174: , hold_days
175: , copy_lot_attribute_flag
176: FROM mtl_system_items
177: WHERE inventory_item_id = p_inventory_item_id
178: AND organization_id = p_organization_id;
179:
180: END get_opm_item_attributes;

Line 397: FROM mtl_system_items

393: l_copy_lot_attribute_flag := NVL(l_lot_uom_conv.copy_lot_attribute_flag,'N') ;
394:
395: ELSIF l_lot_uom_conv.lot_number_generation IN (2,3) THEN
396: SELECT copy_lot_attribute_flag INTO l_copy_lot_attribute_flag
397: FROM mtl_system_items
398: WHERE inventory_item_id = p_inventory_item_id
399: AND organization_id = p_organization_id;
400: END IF;
401: ELSIF c_lot_uom_conv%FOUND THEN

Line 403: FROM mtl_system_items

399: AND organization_id = p_organization_id;
400: END IF;
401: ELSIF c_lot_uom_conv%FOUND THEN
402: SELECT copy_lot_attribute_flag INTO l_copy_lot_attribute_flag
403: FROM mtl_system_items
404: WHERE inventory_item_id = p_inventory_item_id
405: AND organization_id = p_organization_id;
406:
407: END IF ;

Line 479: FROM mtl_system_items_b

475: , expiration_action_interval
476: , retest_interval
477: , maturity_days
478: , hold_days
479: FROM mtl_system_items_b
480: WHERE organization_id = cp_organization_id
481: AND inventory_item_id = cp_inventory_item_id;
482:
483: -- nsinghi bug#5209065 rework START. If existing lot,

Line 702: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

698: , msik.description
699: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
700: , mms.status_code status_code
701: , mms.status_id
702: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
703: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
704: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
705: AND mln.organization_id = p_organization_id
706: AND mln.organization_id = msik.organization_id

Line 721: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

717: , msik.description
718: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
719: , NULL status_code
720: , msik.default_lot_status_id -- Bug#2267947
721: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
722: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
723: AND mln.organization_id = p_organization_id
724: AND mln.organization_id = msik.organization_id
725: AND mln.inventory_item_id = msik.inventory_item_id

Line 737: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

733: , msik.description
734: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
735: , mms.status_code status_code
736: , mms.status_id
737: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
738: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
739: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
740: AND mln.organization_id = p_organization_id
741: AND mln.organization_id = msik.organization_id

Line 756: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

752: , msik.description
753: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
754: , NULL status_code
755: , msik.default_lot_status_id -- Bug#2267947
756: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
757: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
758: AND mln.organization_id = p_organization_id
759: AND mln.organization_id = msik.organization_id
760: AND mln.inventory_item_id = msik.inventory_item_id

Line 777: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

773: , msik.description
774: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
775: , mms.status_code
776: , mms.status_id
777: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
778: WHERE moq.organization_id = p_organization_id
779: AND moq.lot_number IS NOT NULL
780: AND moq.organization_id = mil.organization_id
781: AND moq.organization_id = mln.organization_id

Line 806: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

802: , msik.description
803: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
804: , NULL status_code
805: , msik.default_lot_status_id -- Bug#2267947
806: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
807: WHERE moq.organization_id = p_organization_id
808: AND moq.lot_number IS NOT NULL
809: AND moq.organization_id = mil.organization_id
810: AND moq.organization_id = mln.organization_id

Line 836: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

832: , msik.description
833: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
834: , mms.status_code
835: , mms.status_id
836: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
837: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
838: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
839: AND mln.organization_id = p_organization_id
840: AND mln.organization_id = msik.organization_id

Line 855: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

851: , msik.description
852: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
853: , NULL status_code
854: , msik.default_lot_status_id -- Bug#2267947
855: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
856: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
857: AND mln.organization_id = p_organization_id
858: AND mln.organization_id = msik.organization_id
859: AND mln.inventory_item_id = msik.inventory_item_id

Line 876: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

872: , msik.description
873: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
874: , mms.status_code
875: , mms.status_id
876: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
877: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
878: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
879: AND mln.organization_id = p_organization_id
880: AND mln.organization_id = msik.organization_id

Line 895: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

891: , msik.description
892: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
893: , NULL status_code
894: , msik.default_lot_status_id -- Bug#2267947
895: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
896: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
897: AND mln.organization_id = p_organization_id
898: AND mln.organization_id = msik.organization_id
899: AND mln.inventory_item_id = msik.inventory_item_id

Line 1219: l_ITEM_DUAL_UOM_CONTROL mtl_system_items.tracking_quantity_ind%TYPE ;

1215: L_LOT_UOM_CONVERSION VARCHAR2(10);
1216: l_sec_qty Number := 0;
1217: l_primary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1218: l_primary_quantity NUMBER ;
1219: l_ITEM_DUAL_UOM_CONTROL mtl_system_items.tracking_quantity_ind%TYPE ;
1220: l_copy_pnt_lot_att_flag mtl_system_items.copy_lot_attribute_flag%TYPE ;
1221: l_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE ;
1222: l_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
1223: /* Cursor definition to get Item attributes*/

Line 1220: l_copy_pnt_lot_att_flag mtl_system_items.copy_lot_attribute_flag%TYPE ;

1216: l_sec_qty Number := 0;
1217: l_primary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1218: l_primary_quantity NUMBER ;
1219: l_ITEM_DUAL_UOM_CONTROL mtl_system_items.tracking_quantity_ind%TYPE ;
1220: l_copy_pnt_lot_att_flag mtl_system_items.copy_lot_attribute_flag%TYPE ;
1221: l_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE ;
1222: l_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
1223: /* Cursor definition to get Item attributes*/
1224: cursor c_get_item_attr

Line 1221: l_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE ;

1217: l_primary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1218: l_primary_quantity NUMBER ;
1219: l_ITEM_DUAL_UOM_CONTROL mtl_system_items.tracking_quantity_ind%TYPE ;
1220: l_copy_pnt_lot_att_flag mtl_system_items.copy_lot_attribute_flag%TYPE ;
1221: l_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE ;
1222: l_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
1223: /* Cursor definition to get Item attributes*/
1224: cursor c_get_item_attr
1225: IS

Line 1222: l_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;

1218: l_primary_quantity NUMBER ;
1219: l_ITEM_DUAL_UOM_CONTROL mtl_system_items.tracking_quantity_ind%TYPE ;
1220: l_copy_pnt_lot_att_flag mtl_system_items.copy_lot_attribute_flag%TYPE ;
1221: l_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE ;
1222: l_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
1223: /* Cursor definition to get Item attributes*/
1224: cursor c_get_item_attr
1225: IS
1226: SELECT primary_uom_code

Line 1231: FROM mtl_system_items

1227: , secondary_uom_code
1228: , secondary_default_ind
1229: , copy_lot_attribute_flag
1230: , tracking_quantity_ind
1231: FROM mtl_system_items
1232: WHERE organization_id = p_org_id
1233: AND inventory_item_id = p_inventory_item_id ;
1234:
1235: l_get_item_attr c_get_item_attr%ROWTYPE ;