DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on MTL_ITEM_FLEXFIELDS

Line 374: l_Item_number mtl_item_flexfields.item_number%TYPE;

370: /************************
371: * Local Variables *
372: ************************/
373:
374: l_Item_number mtl_item_flexfields.item_number%TYPE;
375:
376: /****************
377: * Cursors *
378: ****************/

Line 386: FROM mtl_item_flexfields

382: p_Inventory_item_id IN NUMBER
383: )
384: IS
385: SELECT item_number
386: FROM mtl_item_flexfields
387: WHERE inventory_item_id = p_inventory_item_id
388: AND ROWNUM = 1;
389:
390: BEGIN

Line 6567: l_item MTL_ITEM_FLEXFIELDS.item_number%TYPE;

6563:
6564: x_order_tbl my_order_tbl;
6565:
6566: l_inventory_item_id MTL_SYSTEM_ITEMS_B.inventory_item_id%TYPE;
6567: l_item MTL_ITEM_FLEXFIELDS.item_number%TYPE;
6568: l_customer_no OP_CUST_MST.cust_no%TYPE;
6569: l_vendor_site_id PO_VEND_MST.of_vendor_site_id%TYPE;
6570: l_taxauth_code TX_TAXA_MST.taxauth_code%TYPE;
6571: l_Charge_code OP_CHRG_MST.Charge_code%TYPE;