[Home] [Help]
955: ood.organization_id warehouse_id,
956: ood.organization_code warehouse_code,
957: ood.organization_name warehouse_name
958: FROM
959: org_organization_definitions ood
960: WHERE
961: operating_unit = to_number(p_search_text2)
962: AND p_search_criteria2 = 'ORG_ID'
963: AND ((ood.organization_code LIKE p_search_text1
1037: sum(moqd.transaction_quantity) onhand_qty,
1038: moqd.transaction_uom_code
1039: FROM
1040: mtl_onhand_quantities_detail moqd,
1041: org_organization_definitions ood,
1042: mtl_parameters mp
1043: WHERE
1044: moqd.organization_id = ood.organization_id AND
1045: moqd.inventory_item_id = p_inventory_item_id AND
1060: ood.organization_name warehouse,
1061: ood.organization_id warehouse_id
1062: FROM
1063: mtl_onhand_quantities_detail moqd,
1064: org_organization_definitions ood,
1065: mtl_parameters mp
1066: WHERE
1067: moqd.organization_id = ood.organization_id AND
1068: moqd.inventory_item_id = p_inventory_item_id AND
1086: TRUNC(NVL(moqd.orig_date_received,moqd.date_received)) date_received,
1087: SUM(moqd.transaction_quantity) sum
1088: FROM
1089: mtl_onhand_quantities_detail moqd,
1090: org_organization_definitions ood,
1091: mtl_parameters mp
1092: WHERE
1093: moqd.organization_id = ood.organization_id AND
1094: moqd.inventory_item_id = p_inventory_item_id AND
1216: sum(moqd.transaction_quantity) onhand_qty,
1217: moqd.transaction_uom_code
1218: FROM
1219: mtl_onhand_quantities_detail moqd,
1220: org_organization_definitions ood,
1221: mtl_parameters mp
1222: WHERE
1223: moqd.organization_id = ood.organization_id AND
1224: moqd.inventory_item_id = p_inventory_item_id AND
1239: ood.organization_name warehouse,
1240: ood.organization_id warehouse_id
1241: FROM
1242: mtl_onhand_quantities_detail moqd,
1243: org_organization_definitions ood,
1244: mtl_parameters mp
1245: WHERE
1246: moqd.organization_id = ood.organization_id AND
1247: moqd.inventory_item_id = p_inventory_item_id AND
1265: (NVL(moqd.orig_date_received,moqd.date_received)) date_received,
1266: SUM(moqd.transaction_quantity) Onhand_quantity
1267: FROM
1268: mtl_onhand_quantities_detail moqd,
1269: org_organization_definitions ood,
1270: mtl_parameters mp
1271: WHERE
1272: moqd.organization_id = ood.organization_id AND
1273: moqd.inventory_item_id = p_inventory_item_id AND
2159: cursor get_warehouse_csr(p_organization_id IN NUMBER) is
2160: SELECT
2161: ood.organization_name warehouse
2162: FROM
2163: org_organization_definitions ood
2164: WHERE
2165: ood.organization_id = p_organization_id;
2166: l_warehouse_tbl warehouse_tbl_type := p_warehouse_tbl;
2167: