[Home] [Help]
1709: msi.segment1 INVENTORY_ITEM_NAME,
1710: msi.description INVENTORY_ITEM_DESCRIPTION
1711: FROM okc_k_items item,
1712: okc_k_lines_b cleb_item,
1713: MTL_SYSTEM_ITEMS_B msi
1714: WHERE item.cle_id = cleb_item.id
1715: AND cleb_item.lse_id = 34
1716: AND msi.inventory_item_id = item.object1_id1
1717: AND msi.organization_id = item.object1_id2) item_line,
1867: lookup_usage.meaning USAGE_TYPE
1868: FROM
1869: OKC_RULES_B RUL,
1870: OKC_RULE_GROUPS_B RG,
1871: mtl_system_items_b mtl,
1872: mtl_system_items_tl mtl_tl,
1873: OKX_LIST_HEADERS_V OKX_PRICE,
1874: OKC_K_LINES_B CLE,
1875: fnd_lookup_values_vl lookup_read,
3821: msi.segment1 INVENTORY_ITEM_NAME,
3822: msi.description INVENTORY_ITEM_DESCRIPTION
3823: FROM okc_k_items item,
3824: okc_k_lines_b cleb_item,
3825: MTL_SYSTEM_ITEMS_B msi
3826: WHERE item.cle_id = cleb_item.id
3827: AND cleb_item.lse_id = 34
3828: AND msi.inventory_item_id = item.object1_id1
3829: AND msi.organization_id = item.object1_id2) item_line,
3971: lookup_usage.meaning USAGE_TYPE
3972: FROM
3973: OKC_RULES_B RUL,
3974: OKC_RULE_GROUPS_B RG,
3975: mtl_system_items_b mtl,
3976: mtl_system_items_tl mtl_tl,
3977: OKX_LIST_HEADERS_V OKX_PRICE,
3978: OKC_K_LINES_B CLE,
3979: fnd_lookup_values_vl lookup_read,
5802: msi.segment1 INVENTORY_ITEM_NAME,
5803: msi.description INVENTORY_ITEM_DESCRIPTION
5804: FROM okc_k_items item,
5805: okc_k_lines_b cleb_item,
5806: MTL_SYSTEM_ITEMS_B msi
5807: WHERE item.cle_id = cleb_item.id
5808: AND cleb_item.lse_id = 34
5809: AND msi.inventory_item_id = item.object1_id1
5810: AND msi.organization_id = item.object1_id2) item_line,
6007: lookup_usage.meaning USAGE_TYPE
6008: FROM
6009: OKC_RULES_B RUL,
6010: OKC_RULE_GROUPS_B RG,
6011: mtl_system_items_b mtl,
6012: mtl_system_items_tl mtl_tl,
6013: OKX_LIST_HEADERS_V OKX_PRICE,
6014: OKC_K_LINES_B CLE,
6015: fnd_lookup_values_vl lookup_read,