APPS.DPP_UTILITY_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1002: org_organization_definitions ood

998: ood.organization_id warehouse_id,
999: ood.organization_code warehouse_code,
1000: ood.organization_name warehouse_name
1001: FROM
1002: org_organization_definitions ood
1003: WHERE
1004: operating_unit = to_number(p_search_text2)
1005: AND p_search_criteria2 = 'ORG_ID'
1006: AND ((ood.organization_code LIKE p_search_text1 || '%'

Line 1080: org_organization_definitions ood,

1076: sum(moqd.transaction_quantity) onhand_qty,
1077: moqd.transaction_uom_code
1078: FROM
1079: mtl_onhand_quantities_detail moqd,
1080: org_organization_definitions ood,
1081: mtl_parameters mp
1082: WHERE
1083: moqd.organization_id = ood.organization_id AND
1084: moqd.inventory_item_id = p_inventory_item_id AND

Line 1103: org_organization_definitions ood,

1099: ood.organization_name warehouse,
1100: ood.organization_id warehouse_id
1101: FROM
1102: mtl_onhand_quantities_detail moqd,
1103: org_organization_definitions ood,
1104: mtl_parameters mp
1105: WHERE
1106: moqd.organization_id = ood.organization_id AND
1107: moqd.inventory_item_id = p_inventory_item_id AND

Line 1129: org_organization_definitions ood,

1125: TRUNC(NVL(moqd.orig_date_received,moqd.date_received)) date_received,
1126: SUM(moqd.transaction_quantity) sum
1127: FROM
1128: mtl_onhand_quantities_detail moqd,
1129: org_organization_definitions ood,
1130: mtl_parameters mp
1131: WHERE
1132: moqd.organization_id = ood.organization_id AND
1133: moqd.inventory_item_id = p_inventory_item_id AND

Line 1256: org_organization_definitions ood,

1252: sum(moqd.transaction_quantity) onhand_qty,
1253: moqd.transaction_uom_code
1254: FROM
1255: mtl_onhand_quantities_detail moqd,
1256: org_organization_definitions ood,
1257: mtl_parameters mp
1258: WHERE
1259: moqd.organization_id = ood.organization_id AND
1260: moqd.inventory_item_id = p_inventory_item_id AND

Line 1279: org_organization_definitions ood,

1275: ood.organization_name warehouse,
1276: ood.organization_id warehouse_id
1277: FROM
1278: mtl_onhand_quantities_detail moqd,
1279: org_organization_definitions ood,
1280: mtl_parameters mp
1281: WHERE
1282: moqd.organization_id = ood.organization_id AND
1283: moqd.inventory_item_id = p_inventory_item_id AND

Line 1305: org_organization_definitions ood,

1301: (NVL(moqd.orig_date_received,moqd.date_received)) date_received,
1302: SUM(moqd.transaction_quantity) Onhand_quantity
1303: FROM
1304: mtl_onhand_quantities_detail moqd,
1305: org_organization_definitions ood,
1306: mtl_parameters mp
1307: WHERE
1308: moqd.organization_id = ood.organization_id AND
1309: moqd.inventory_item_id = p_inventory_item_id AND

Line 2247: org_organization_definitions ood

2243: cursor get_warehouse_csr(p_organization_id IN NUMBER) is
2244: SELECT
2245: ood.organization_name warehouse
2246: FROM
2247: org_organization_definitions ood
2248: WHERE
2249: ood.organization_id = p_organization_id;
2250: l_warehouse_tbl warehouse_tbl_type := p_warehouse_tbl;
2251: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_WAREHOUSE';