APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 3794: FROM mtl_system_items_b

3790:
3791:
3792: SELECT FULL_LEAD_TIME
3793: INTO l_proc_lead_time
3794: FROM mtl_system_items_b
3795: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3796: AND ORGANIZATION_ID = p_organization_id;
3797:
3798:

Line 4208: FROM mtl_system_items_b

4204: END;
4205:
4206: SELECT FULL_LEAD_TIME
4207: INTO l_proc_lead_time
4208: FROM mtl_system_items_b
4209: WHERE INVENTORY_ITEM_ID =p_inventory_item_id
4210: AND ORGANIZATION_ID = p_organization_id;
4211:
4212:

Line 4805: l_lead_time MTL_SYSTEM_ITEMS_B.full_lead_time%TYPE;

4801: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4802: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4803: l_orig_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
4804: l_long_description MTL_SYSTEM_ITEMS_TL.long_description%TYPE;
4805: l_lead_time MTL_SYSTEM_ITEMS_B.full_lead_time%TYPE;
4806: l_orig_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
4807: l_inventory_item_id PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE;
4808: BEGIN
4809: l_progress := '010';

Line 5013: -- SQL What: Gets the lead time from mtl_system_items_b table

5009: END IF;
5010:
5011: l_progress := '120';
5012: BEGIN
5013: -- SQL What: Gets the lead time from mtl_system_items_b table
5014: -- SQL Why : Need to update lead_time value of Po_attribute_values
5015: -- if it does not match withmtl_system_items_b lead_time.
5016: -- SQL Join:
5017: SELECT full_lead_time

Line 5015: -- if it does not match withmtl_system_items_b lead_time.

5011: l_progress := '120';
5012: BEGIN
5013: -- SQL What: Gets the lead time from mtl_system_items_b table
5014: -- SQL Why : Need to update lead_time value of Po_attribute_values
5015: -- if it does not match withmtl_system_items_b lead_time.
5016: -- SQL Join:
5017: SELECT full_lead_time
5018: INTO l_lead_time
5019: FROM mtl_system_items_b

Line 5019: FROM mtl_system_items_b

5015: -- if it does not match withmtl_system_items_b lead_time.
5016: -- SQL Join:
5017: SELECT full_lead_time
5018: INTO l_lead_time
5019: FROM mtl_system_items_b
5020: WHERE inventory_item_id = l_inventory_item_id
5021: AND organization_id = p_org_id;
5022:
5023: EXCEPTION

Line 6673: FROM mtl_system_items_b

6669:
6670: -- Get LEAD_TIME
6671: SELECT full_lead_time
6672: INTO p_lead_time
6673: FROM mtl_system_items_b
6674: WHERE inventory_item_id = p_inventory_item_id
6675: AND organization_id = l_inv_organization_id;
6676:
6677: IF PO_LOG.d_stmt THEN